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?
Answers
-
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)
-
Thank you I will try it
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!