Formula to blank cell in column if another column cell is blank?
I this formula in the "Drawings Status" column =IF(AND([Drawings Received]@row = "", [Drawings Quoted]@row <= TODAY()), "Yellow", "Green"). The problem is I want the "Drawings Status" column to be blank if the "Drawings Quoted" column is blank. Right now the status column will turn yellow if its blank. In short I'd like a formula that will turn the status column green if the "Drawings Received column is populated, turn the status column yellow if we pass the date in the "Drawings Quoted" column by 1 day, and turn the status column blank if the "drawings Quoted" column is blank.
Answers
-
Hi @Myles Armstrong,
Give this a try. =IF(ISBLANK([Drawings Quoted]@row), "", IF(AND([Drawings Received]@row = "", [Drawings Quoted]@row <= TODAY()), "Yellow", "Green"))
Hope this helps,
Dave
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!