Record a Date Automation

Hi!

Has anyone found a way to use Smartsheet automations to update a date filed a SPECIFIC date?

I want to find a way without building a helper sheet, or wasting space with helper columns, to record a specific archive date once a project is marked as "complete." I would like to archive all completed projects, regardless of when complete on the first day of our fiscal year.

In summary, if Project Status is "Complete" record "06/30/2025" in a date field, if false, then date field is blank.

Thanks!!!

MW

Answers