Is there a way to 'automate' the filling of a DATE column via a formula?

Reece J
Reece J
edited 08/23/22 in Formulas and Functions

Hi Community,

My scenario: I am using a MIN/COLLECT formula to pull the earliest date from a list after a set criterion is met.

I now want to have the same field 'lock-in' the date when another criterion is met, column x = "Scheduled".

I am unsure if this is possible without creating a circular dependency.

I did think to create a dummy column and then have the automation copy over the original formula when the dummy column met a criteria but you can't do this with a date field in smartsheet.

Any help would be appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!