Run a formula if a cell is "not" blank

Yvonne Cunningham

My formula exists in the Left Before Training Started column. I'd like to return if a cell in the Leave Date column is blank, return a blank. If it is NOT blank, I want to determine if the date in that column is before the date in the Training Start Date column. If yes, then return the word "BEFORE" to indicate they left before the training started.

Why is my formula not working!

=IF(ISBLANK([Leave Date]@row, "", ([Training Start Date]@row < [Leave Date]@row, "BEFORE"))

Thank you!

Andrée Starå

@Yvonne Cunningham

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!

Andrée Starå

Hi @Yvonne Cunningham

I hope you're well and safe!

Try something like this.

=IF([Leave Date]@row = "", "", IF([Training Start Date]@row < [Leave Date]@row, "BEFORE")

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!

Yvonne Cunningham

YES! Thank you so much! Such a simple addition, but it worked perfectly! I am so grateful!😃

Andrée Starå

@Yvonne Cunningham

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!

JustinG

Hello - I am having a similar issue. I want to return a blank if nothing was entered, but to run the below formula if there is an entry. The below formula works if there is an entry, but I am having trouble creating a formula that combines this formula with an if statement that returns a blank if blank.

=LEFT([COMMODITY CODE]@row, FIND("*", [COMMODITY CODE]@row) - 1)

Andrée Starå

https://community.smartsheet.com/discussion/comment/390491#Comment_390491

Hi,

I hope you're well and safe!

Try something like this.

=IF([COMMODITY CODE]@row<>"", LEFT([COMMODITY CODE]@row, FIND("*", [COMMODITY CODE]@row) - 1)

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

JustinG

https://community.smartsheet.com/discussion/comment/390493#Comment_390493

Thank you so much @Andrée Starå. That worked like a charm!

Andrée Starå

https://community.smartsheet.com/discussion/comment/390498#Comment_390498

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Felkernic

Hello Everyone,

I had this same question today @JustinG. Thank you @Andrée Starå for providing a great solution. You both saved me a lot of time trying to figure it out myself!

Take Care,

Nicole

Andrée Starå

https://community.smartsheet.com/discussion/comment/390668#Comment_390668

Hi,

I hope you're well and safe!

Glad to hear it was helpful!

Happy to help!

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!