Writing today's date into a cell when the Status value in the same row contains "Complete" or "N/A"

Hi Community!

I try to write today's date into a cell when the Status value in the same row contains "Complete" or "N/A". Any suggestions or hints how this formula could look like? Thanks!

Best Answer

  • Nick Korna
    Nick Korna Community Champion
    Answer ✓

    Hi @Ulrich Anderhub 1,

    You would probably want to do this via automation than with a formula, as a formula would give the date as today - every day. For example, it would show tomorrow's date tomorrow if you looked at the sheet.

    The automation setup is pretty simple though, along the lines of this:

    image.png

    Just make sure your date column is set up with Date as type to be able to record the date into it!

    Hope this helps, but if you've any issues then just ask!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!