Formula: If Status Changes to Something After Date
I'd like help in creating a formula that depends on another cell changing to a specific status, not if it is that status already.
E.g. to have a checkbox get checked if the status balls of a neighboring cell turn red (after a certain time and date- the time and date of which I input the formula), but not if they were red already.
Thank you
Comments
-
Hi,
Try this.
=IF(AND(Symbols@row = "red"; TODAY() = [After Date]@row); 1; 0)
After Date is the column with the date that you want the checkbox to get checked if the RYG is red. (unfortunately, there isn't an easy hour option but it could probably be done with some helper columns) Also, it's important that you know that the checkbox will only get checked if the sheet is opened.
Symbols are the RYG column
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!