Days to Launch, stop at Zero

I have created a formula to countdown the days to launch and converted it to a Column forumula so it is automatic for any project. However, we don't need to know the negative numbers or day past launch in this column. I tried nesting an IF function to return a blank cell for anything less than zero but I the dreaded unparseable error. What am I missing?

=[Go Live/Close Date]@row - TODAY(), IF([Days to Go Live]@row, <0, "")


Tags:

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Tina Rustvold

    Here's one approach to your problem

    =IF([Go Live/Close Date]@row>=TODAY(), [Go Live/Close Date]@row - TODAY())

    This checks to see if Go Live Date is greater than today's date. If yes, the calculation occurs. If not, a blank will be returned.

    Is the Status ever 'Closed' when the Go Live date is still in the future? If yes, you could instead use Status not equaling Closed to drive the calculation: =IF(Status@row<>"Closed", [Go Live/Close Date]@row - TODAY())

    cheers

  • Tina Rustvold
    Tina Rustvold ✭✭✭✭✭

    Thanks for that suggestion Kelly; that might actually work better. However, we have Done checkbox that would be the most reliable criteria so I tried the following and got an Incorrect Arguement Set--closer than Unparseable but not sure what the system doesn't like about it.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!