What constitutes a "change" for triggering a workflow? Can a cross-sheet reference be used?
I am going to explain the problem, but the details are not important as I really just want to know what constitutes a change, and if I can use a change in a cross-sheet field as a workflow trigger.
I am trying to trigger a workflow based on a row change in a sheet where every cell is a lookup. I have workflow that copies a row to a sheet (call this sheet HOLDING), and I need to transform that data before moving it along to another sheet. Row data will get copied to HOLDING one at time. I have another sheet (TRANFORM) that looks at HOLDING and uses MAX to pull the most recent record added to HOLDING. The TRANFORM sheet only has one record on it ever. As soon as a new record is added to HOLDING, a manual refresh of TRANSFORM will change what is shown. But Smartsheet apparently does not consider the refresh of cross-sheet data to be a change.
I have a similar situation with another sheet, but in that case I just need to have a daily refresh, so I just use the Record a Date workflow to update a field every night at 10PM. That is enough to trigger the change. I have through about setting a Record a Date workflow to run every hour because that's as granular as Smartsheet can get, but I need the solution to be able to run more frequently.
I asked this question here, but since that one is not getting any responses, I thought I would break this down to just ask about triggers.
Help Article Resources
Check out the Formula Handbook template!