Using Automations to Add End of Month Date to New Row
I'm relatively new to Smartsheet. I have a sheet that I would like to use a workflow to automatically enter the date at the end of the month to the next row. So, on January 31, I would like the workflow to run and enter 1/31/24 in a date column on the next blank row. I've tried using the Record a Date action in a workflow, but it changes the date for all rows. Is there a way to do this?
Help Article Resources
Check out the Formula Handbook template!