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

Ulrich Anderhub 1

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!

Nick Korna

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:

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!

Nick Korna

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:

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!

Ulrich Anderhub 1

Thanks, works like a charm... :-)

Nick Korna

Glad to have helped! 😊