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

LesahDee

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

@LesahDee

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