Help with days remaining counter formula

Options

Hello,

I am having an issue where if a date is entered in the 'submitted' column, the counter does not go away. I would like the 'days remaining' counter to stop if the 'submitted' column is populated:

=IF(ISBLANK([GWS-09 Submitted]@row), [GWS-09 Due (within 60 days of Abandonment)]@row - TODAY(), IF([GWS-09 Due (within 60 days of Abandonment)]@row - TODAY() < 0, "", [GWS-09 Due (within 60 days of Abandonment)]@row - TODAY()))

Answers

  • Will Jeffords
    Will Jeffords ✭✭✭✭✭✭
    Options

    Hi @sriccobono,

    Try inverting the last part of your formula to position the "then" part of the IF as follows:

    =IF(ISBLANK([GWS-09 Submitted]@row), [GWS-09 Due (within 60 days of Abandonment)]@row - TODAY(), IF([GWS-09 Due (within 60 days of Abandonment)]@row - TODAY() >= 0, [GWS-09 Due (within 60 days of Abandonment)]@row - TODAY(),""))

    I'm posting this before I test it, but I think this might be the issue. I will test in a bit myself.

    Cheers,

    Will

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!