Automation between sheets

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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!