IF And formula with cross sheet reference gives invalid operation error

Hi team,

This is probably so obvious but i don't manage to get the following formula to work:

=IF(AND({EMEA KPI General data Country} = Country@row, {EMEA KPI General data Payroll month} = Month@row), {EMEA KPI General data Reason for manual pay})

I get error invalid operation. Can you help?

Thanks

Judith

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!