return cell value from another sheet

Options
db0617
db0617
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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!