Usage of IF formula between sheets


I am using the IF formula to obtain a result in my sheet if the code is the same i have in another sheet.

Example: Smartsheet1, If in cell A1 I have code "123", i need to verify if the same code appears in Smartsheet 2 and if yes i want that in Cell A2 of Smartsheet1 is reported the info that i can read in cell A2 of the Smartsheet 2

Is the example clear?

I tried and i have this formula:

=IF([Document Number]1 = {SAP OPS REPORT Intervallo 1}; {SAP OPS REPORT Intervallo 2}; NA)

But in the cell i get: #UNPARASABLE

Can you please address me?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!