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

kowal Overachievers Alumni

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.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!