Cross sheet IF formula

edited 07/13/23 in Formulas and Functions

I am getting Unparseable error for this formula:

=IF({Reference sheet 1} >= {Reference sheet 2} "Yes", "No").

I am trying to determine if number in sheet 1 is greater than sheet 2 in a particular column, then input yes in the 3rd sheet and vice versa.

Is it possible to use IF formula across sheets? If so, what am I missing? Thank you!


  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    You need to specify what in each sheet you are wanting to reference. {Reference sheet 1} will point to the entire column in that sheet. Is there a specific cell in that column you are looking at?

  • Thanks for the reply! I want it to be the same cell within column in each sheet. How do I specify this?

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    So you essentially have a column of numbers in Sheet 1 and a column of numbers in Sheet 2, and then want to compare them row-by-row between those two sheets?

    If that is the case, you need a way to identify each row in order to compare them in each of the three sheets. Something like an ID row in each sheet, numbered sequentially. You would then match the "ID" row between the sheets in order to retrieve the values you are looking for to compare.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!