Cell shows #REF syntax after sheet was auto updated via Data Shuttle Workflow

edited 05/23/24 in Formulas and Functions

I was trying to map reference a cell using SUMIFS formula from the Email_DB sheet (that is linked to an Excel sheet via Workflow), it was able to capture the data at the beginning but every time after the workflow process is ran and updated Email_DB sheet the value cell will show #REF

Any idea why is that so? or I did something wrong here?

Would appreciate if anyone could help give some guidance. Thanks.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!