Is there a workaround to have a column with date (as function) to be recognised by workflows?

kowal

Dear Smartsheet Users,

For my solution I need to have a date (always the same) in one column for more than 100 rows.

The easiest way for me to do it is to write e.g.: ="03/04/23" and change this column to formula one so the same date will be for next row etc.

However despite it's a Date column the workflows are not being sent on this proper date? of course I can also write the date 03/04/23 but then I need to add each time.

Paul Newcome

When you have a value wrapped in "quotes", it is treated as a text value. To get an actual date value, you would need to use the DATE function.

=DATE(yyyy, mm, dd)

Paul Newcome

Happy to help. 👍️

Paul Newcome

When you have a value wrapped in "quotes", it is treated as a text value. To get an actual date value, you would need to use the DATE function.

=DATE(yyyy, mm, dd)

[Deleted User]

Thanks Paul!

Paul Newcome

Happy to help. 👍️