Avoiding negative values after past date

Options

Hello,

I want to display a countdown of the number of days remaining to return to work based on the scheduled day the 'leave ends'. I am using the following formula which works except that a negative value populates after the leave has passed:

=[Leave Ends]@row - TODAY()


How can I avoid getting a negative value and instead to leave the area blank when the leave has ended?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!