How do I un-flag automatically?
I am wondering how to unflag in my sheet automatically
I need it to flag when start date and/or finish date is in the past and status is not "completed"
I then also need it to un-flag when the status column is changed to completed or rejected
Anyone know of a formula?
Answers
-
A nested IF statement is probably the best route for formula, but some conditional formatting could work as well. Can you provide more information on what you mean by "flag" or a screenshot for reference?
Cheers,
John
-
@John Shane conditional formatting wont work because I cannot filter by color. Has to be a flag
-
Nested IF definitely seems to be the way to go. What are the names of the columns you are needing to reference?
-
@John Shane Start date, finish date, status
Then we I have the two flag columns above
-
This should work for the Late Start column. You will need to change [Start Date] to [Finish Date] for the Late Finish column.
= IF(OR(Status@row = “Completed”, Status@row = “Rejected”), 0, IF(AND(Status@row <> “Completed”, [Start Date] < TODAY()), 1, 0))
Cheers,
John
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!