Formula help  how to leave blank when Actual Finish is empty
Can someone help complete this formula?  looking for the 'Task Health' column to be empty when Actual Finish is blank, meaning task is not complete yet. Everything I've tried is either unparseable or results in a value.
=IF([Actual Finish]@row > [Planned Finish]@row, "Late",
IF([Actual Finish]@row = [Planned Finish]@row, "On Time",
IF([Actual Finish]@row < [Planned Finish]@row, "Early", "")))
Best Answers

Try something like this.
=IF([Actual Finish]@row = ""; ""; IF([Actual Finish]@row > [Planned Finish]@row; "Late"; IF([Actual Finish]@row = [Planned Finish]@row; "On Time"; IF([Actual Finish]@row < [Planned Finish]@row; "Early"; ""))))
The same version but with the below changes for convenience.
=IF([Actual Finish]@row = "", "", IF([Actual Finish]@row > [Planned Finish]@row, "Late", IF([Actual Finish]@row = [Planned Finish]@row, "On Time", IF([Actual Finish]@row < [Planned Finish]@row, "Early", ""))))
Depending on your country/region, you'll need to exchange the comma to a period and the semicolon to a comma.
Did that work?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Excellent!
You're more than welcome!
I saw that David answered the followup question.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers

Try something like this.
=IF([Actual Finish]@row = ""; ""; IF([Actual Finish]@row > [Planned Finish]@row; "Late"; IF([Actual Finish]@row = [Planned Finish]@row; "On Time"; IF([Actual Finish]@row < [Planned Finish]@row; "Early"; ""))))
The same version but with the below changes for convenience.
=IF([Actual Finish]@row = "", "", IF([Actual Finish]@row > [Planned Finish]@row, "Late", IF([Actual Finish]@row = [Planned Finish]@row, "On Time", IF([Actual Finish]@row < [Planned Finish]@row, "Early", ""))))
Depending on your country/region, you'll need to exchange the comma to a period and the semicolon to a comma.
Did that work?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

That worked perfectly  thank you @Andrée Starå
you said, "Depending on your country/region, you'll need to exchange the comma to a period and the semicolon to a comma.' Can you further explain the logic behind the semi colon, comma, period and what works in the formula? the semicolon is in quotes and then also not in quotes.
Want to make sure I understand how to apply in the future to other needs.
Many thanks for the assist!

The thing about semi colon and comma is that all smartsheet versions doesn't exactly works the same depending of your region.
As a french guy for example, my version requires semi colon, to separates values, ranges, within functions. But lurking around here quite often and typing function in the Us type is now leading me into small trouble as I've taken the habit to separates values within functions with commas instead of semi colon. And each time that happens, the formula returns me an #UNPARSEABLE error :D
That's just what Andree's meaning here.
Also, notes that Andree didn't put semi colon within quotes in his formula. The first one is between two double quotes. Double quotes is equal BLANK cell for smartsheet.
Hope it helped!

Excellent!
You're more than welcome!
I saw that David answered the followup question.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:[email protected]  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
Check out the Formula Handbook template!