Will the automation “Request an update” fail if the 'Condition' column contains a cross-sheet formula that pulls data from another sheet?
For example, there are two Smartsheets:
Sheet ONE contains Project ID, MFG Rep and Customer Price. This is the source sheet for Project ID and MFG Rep.
Sheet TWO contains Project ID, MFG Rep, Vendor Cost and Ship Date.
Instead of typing or selecting duplicate info on two sheets, we link Sheet TWO ‘Project ID’ to Sheet ONE ‘Project ID’, and we use cross-sheet formulas (index/match) to pull in MFG Rep name from Sheet ONE. In Sheet TWO, I have setup an 'Request an update' automation workflow based on Sheet TWO MFG Rep (column contains the cross-sheet formula) and if the column contains the Reps first name, email them a Request for Update Form so the Rep can enter Vendor Cost on Sheet TWO.
I noticed that the sheet TWO MFG Reps are not getting the email. Is it because the ‘condition where’ column cannot contain a formula?
Thank you for your help!