Formula if cell is blank then, if cell is not blank then....
Formula gods, looking for help, please.
I'm trying to write a formula that says if the finish date is not blank, then the QA status is Green, if finish date is blank, then go to the days open field and if less than >= 60 and <=89 then Yellow, if days open is >=90 then Red.
I can write the individual formulas to get the red to work and an indivudual formula to get the yellow and green to work, but not work together as one string.
Help!
Many thanks!
Comments

You are actually very close already and have the right idea established. The same way you nested the "Red" at the end of the "Yellow"... You would take that nested IF and nest it after "Green".
=IF(NOT(ISBLANK([Finish Date]@row)), "Green", nested_if_for_yellow_and_red)

Hi Melissa,
It looks like you were really close to getting your formula to work. If you received an #INCORRECT ARGUMENT SET error it's because the last portion of your formula begins with IF(AND( but only one logical expression was given.
Here's what your formula should look like:
=IF(NOT(ISBLANK([Finish Date]@row)), "Green", IF(AND([Days Open]@row >= 60, [Days Open]@row <= 89), "Yellow", IF([Days Open]@row >= 90, "Red")))
I also noticed that if the finished date is blank, but the number of days open is less than 60, nothing is returned. If you would like to return a green symbol when the finish date is blank, but the number of days open is less than 60, you could use the formula below:
=IF(NOT(ISBLANK([Finish Date]@row)), "Green", IF([Days Open]@row < 60, "Green", IF(AND([Days Open]@row >= 60, [Days Open]@row <= 89), "Yellow", IF([Days Open]@row >= 90, "Red"))))
Hope this helped!

I posted my response a couple minutes too late. Thanks for chiming in Paul!

Haha. No worries. That seems to happen a lot here in the Community.

That did it! You all are awesome! Thank you so much!


I have a similar scenario, but I'd like to return a value in a cell based on a date field at that row. I got this to work as far as =IF(NOT(ISBLANK([Date]@row)), "Not Started"...thanks to your help above.
Now, how do I add a condition where if the "Date" column has a date entered (i.e. is not blank), then the return is "In Progress", to the above formula?
Thank you!

Hi @bentlb3
I hope you're well and safe!
Try something like this.
=IF(Date@row = "", "Not Started", IF(Date@row <> "", "In Progress"))
You could also simplify it if it works for your need.
=IF(Date@row = "", "Not Started", "In Progress")
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.

Thank you! That worked perfectly. I need to add in a separate column now to the formula where if the value in that cell@row is "Yes", then make the value "Complete".
I tried adding to your formula and entering: =IF(Date@row = "", "Not Started", "In Progress", IF(AND(Task Closed?@row = "Yes", "Complete"), but no luck and get the #UNPARSEABLE error.
Any solution to factor in the second criteria to enable the "Complete" value return?
Thank you!

Excellent!
You're more than welcome!
Try something like this for the added criteria.
= IF([Task Closed?]@row = "Yes", "Complete", IF(Dates@row = "", "Not Started", "In Progress"))
Did that work?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.

Worked perfect Andree! Thank you so much!

Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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
 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!