Hello,
I am using an Appsheet app to update a Smartsheet 'metadata' sheet with a status. I have various other sheets that will then be updated based on unique ID's as their status changes on the metadata sheet. Since Smartsheet cannot run a Workflow on cell's changed with cross-sheet references, I have created a "helper" column. My workflow now looks at the helper column to update a checkbox in another cell on the same row.
My issue is that workflow is not triggering based on the helper column after it is updated from the cell that has the cross-sheet reference. My understanding is that the helper column is the best workaround but it isn't working in this case. However, if I delete the formula in the helper column and manually update the helper column, then the checkbox does check on the same row.
Changing the workflow to a time-based trigger is not an option because I need the checkbox to be updated quickly after the 'metadata' sheet is changed. Also, I am not able to use a formula to update the checkbox as the status on the metadata sheet will change but I need the checkbox to remain checked.
