Sign Up ›
  • laptop rent
  • NEWBIE
  • 0 Points
  • Member since 2020
  • RentaPC: Laptop on Rent | Macbooks | Des
  • Rent A PC
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
4 replies

Does anyone know can I have a formula field that can also be a pick list?

Can I have a field that is both a picklist and formula?  The picklist values will be 1 to 72.

I need 1 field to be able to used 2 ways. 

1st – Formula to work out the number of months between 2 date fields and return the result as a number, eg Date 1 = 18 August 2021 / Date 2 is 7 February 2021 Result = 8 (representing 8 months).
AND
2nd - also need people to be able to manually select a value between 1 and 72 from the picklist.

Is this possible or do I need 2 separate fields