*urgent request* - Days until Formula

Dustin Whitehead

Hello SmartSheet World,

I am wondering if there is a good formula that can provide me the number of days until a date is reached?

In the snip below, there will be a date added to the "CO Date ..." column and next to that column I want to create a formula that tells me how many days there are until that date arrives. Is this formula possible? I don't want to use an automation, I just want to populate the number of days.

Thank You,

Dustin

David Tutwiler

I think this would work for you:

=IF(ISDATE([CO Date (Confirmed or Projected)]@row), [CO Date (Confirmed or Projected)]@row - TODAY(), "No Date")

This can be converted to a column formula and will display "No Date" if there isn't a date in the CO column.

David Tutwiler

No problem. Glad it's working.

David Tutwiler

I think this would work for you:

=IF(ISDATE([CO Date (Confirmed or Projected)]@row), [CO Date (Confirmed or Projected)]@row - TODAY(), "No Date")

This can be converted to a column formula and will display "No Date" if there isn't a date in the CO column.

Dustin Whitehead

@David Tutwiler I think that worked, thank you sir!!

David Tutwiler

No problem. Glad it's working.