I need help with a formula or direction if a formula isn't the best way to go

LesahDee ✭✭
edited 09/22/23 in Formulas and Functions

In my sheet I have 4 different dates , requested, procurement, legal and council, and I want the status to change when each date is filled. So if status has a date I want the one quarter symbol, procurement the half symbol, legal 3/4 symbol and council full. can someone help?


  • Leibel S
    Leibel S ✭✭✭✭✭✭


    If it is always in order (first, requested then procurement etc.), then us IF functions starting from the last one, so:

    =IF(Council@row <>"","Full", IF(legal@row<>"","Three Quarter", and keep on going...

    If they can each come at different times, you would use a count of how many are filled and then an IF function as above (starting from 4 and down)

  • LesahDee

    Thank you I will try it

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!