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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!