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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!