Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Need a formula to add a today's date in a date column

Stephanie Taylor
Stephanie Taylor ✭✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

Hello Everyone, 

I am looking for a formula that will add today's date if certain criteria has been met.

 

If "Approved" or "Denied" has been entered into the Status column I would like today's date to automatically be entered in the date column.

 

Thanks in advance.

Stephanie

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    Hi Stephanie,

    You can place a formula in a date column like the following example:

    =IF([Status]1 = “Approved”, TODAY())

    A couple of caveats with this:

    • TODAY() will update to the current date as long as the condition is met, meaning if something was set to “Approved” in your sheet today, but you open the sheet tomorrow, that formula will result in tomorrow’s date being returned.
    • Formula’s can’t exist in date/time columns being used for dependencies.

    Another possibility to explore is a System column that tracks the date/time of the last change made to the row, details on this in the help center: https://help.smartsheet.com/articles/1964567-system-columns

    · Share on FacebookShare on Twitter
  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    This is a big help Shaine.  Thank you.

    This is what I have =IF(Status464 = "Approved", TODAY())

    I would like to have the formula enter today's date if the answer is Approved or Denied.

    How would the formula look? 

    Thanks again, 

    Stephanie

     

    · Share on FacebookShare on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee

    Hi Stephanie,

    You can add the OR function in:

    =IF(OR(Status464 = "Approved", Status464 = "Denied"), TODAY())

    Full disclosure, I didn't test this but I'm confident in the syntax. Let me know if it doesn't work in your sheet and I'll adjust the formula (and my confidence level).

    · Share on FacebookShare on Twitter
  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    Thanks again.  This is a big help.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories