Automation between sheets

David P

I am having an issue with an automation. After an approval request gets approved, it records a date on one sheet, whose information is linked by a formula to another (main) sheet where there is an automation that if the cells in that linked column are a date, then it triggers a check in a check column (Active).

The automation works when I take out the formula linking it to the other sheet and have just a pure date.

I tried a work around where I created an additional check box column to verify if the value in the linked column is a date, and then if that checked column is checked, to check the (Active) column. When the linked column produces a date value, it does in fact check the supplement column, but not the (active) one I want. When I take out the formula and the link, it works great. What am I missing? How can I get the automation to work on the (Active) column based on the formula triggered by the automation for the approval request that produces the date?

Paul Newcome

Automations cannot be triggered by data coming from another sheet. You will need to set the trigger to run on a date basis (can select daily or set up multiple for hourly) and set the condition of that cell containing a date.

Paul Newcome

Automations cannot be triggered by data coming from another sheet. You will need to set the trigger to run on a date basis (can select daily or set up multiple for hourly) and set the condition of that cell containing a date.

David P

Thank you. I thought I had bypassed that by adding the supplememntal columns. This works and now I can remove those.

Paul Newcome

Smartsheet tracks that cross sheet reference/cell link all the way back. I've tried it too. haha.