I wrote a formula to add today’s date when a specific text appeared in another (single select) field. But it doesn’t hold that date; it changes each day. Is there a way to freeze that date to when the text first appeared?
Hi Gordon. You need an automation that triggers on the single select. The action will be to set that date field to the current date, which you can get by having a Last Modified field in the table. Make sense?
No, it won’t change unless someone selects something else in the SS field, and then re-selects the triggering item in the SS field.
You didn’t need to create a view, instead use the “When a record matches conditions” automation trigger. Yes, you always need a field that shows today’s date. Your method is a formula field whereas I suggested using a Last Modified field. Either way should work.