Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions