return cell value from another sheet

edited 06/06/24 in Formulas and Functions

Hi, I would like to return cell values from another sheet if certain conditions are met:

if a box is ticked in Sheet A, the value of another cell in Sheet A shall appear in a cell in Sheet B, but if the box is not ticked, a complex IF-Formula shall be used in the cell in Sheet B.

Is this possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!