Looking for a formula to change RYG status if multiple cell dates are blank?
Looking for a formula that says if the "Drawings Received" "WPS Received" and " ITP Received" column is blank 3 days after the date stated in the "Quoted" columns then turn the "Preconstruction Status" column to Yellow. And would also like it to turn Red if its 7 days after the date in the Quoted column.
Answers
-
To be clear: the condition is if all three are blank, or if any of the three are blank?
The way you can do this is to create two helper columns, one for Quoted+3 and one for Quoted+7. Then you will use another helper column and the TODAY function to figure out if TODAY is greater than Quoted+3 and if it is greater than Quoted+7, and then if it is, then look to see of those received fields are blank, and you use either OR or AND to do that, depending on what you are actually trying to do. From there you use conditional formatting based on the result.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives