urgent request - Days until Formula

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

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.