Hello! I’m trying to timestamp when the value changes in a Status column I've created, but the Status column is formula-driven and its inputs are linked cells / cross-sheet references from multiple source sheets.
- In my Master sheet, the Status column is a formula.
- The fields that drive that formula are not manually edited in the Master sheet - they're pulled in via linked cells from separate source sheets (multiple data sources).
- I created a date column called “Status Last Changed” and set up a workflow:
- Trigger: When rows are changed → when Status changes to any value
- Action: Record a date
Issue: The date field doesn't populate, even though the formula output visibly changes.
Question: Is there a way to timestamp/track when a formula result changes, especially when the inputs are coming from linked or cross-sheet updates? If not, what’s the recommended approach to reliably detect status changes and capture timestamps?
Thank you!
