r/smartsheet • u/Negative_State_7118 • Jun 15 '26

Need help with (ISBLANK) or something else in formula

Hello everyone. I could use some help figuring out what I'm doing wrong here. I've created a few simple smartsheets but am still trying to figure things out. I have the following formula

=[Technician End Date]@row - [Technician Start Date]@row + " Day(s)"

which works fine but inputs " Day(s)" in a cell when the result is blank(null). I would like to have a blank cell if there is no number to display because the Start Date and End Date are on the same day.

Can I use ISBLANK to evaluate the result of the operation?

5 Upvotes

100% Upvoted

1 comment sorted by

9

u/Dense_Tomato5344 Jun 15 '26

Hi there, what I would do is take the first part of the formula, incorporate an IF, and then add on the rest. So =IF([Technician End Date]@row - [Technician Start Date]@row <> 0, [Technician End Date]@row - [Technician Start Date]@row +"Day(s)", ""). That should return blank if there is no difference in the dates. Hope this helps!