Formula If & AND referencing form another sheet

Is there a formula for the following scenario referencing from another sheet?

if "checkbox = ticked under Unique column" AND "Fruit = Apple" Then display [color]@row

Refer to below, result I want to get is "Green"

=IF(AND({SheetA Range 3}=1, {SheetA Range 2}=Apple), {SheetA Range 4})

I tried with above formula, but didnt work. =(

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!