Smartsheet Summary RYG across multiple sheets/cells

Deb Fuller · 05/18/21

I want to provide an overall RYG status tied to multiple sheets.

What is the best reference for determining the formula to do so?

Mark Cronk · 05/19/21

Hi Deb,

You'll need to use nested IF statements with cross sheet references. Link to video below, but there are lots of good threads in the community.

Good luck.

Mark

Mark Cronk · 05/19/21

Hi Deb,

You'll need to use nested IF statements with cross sheet references. Link to video below, but there are lots of good threads in the community.

Good luck.

Mark

Deb Fuller · 05/21/21

Thank you Mark!

Mark Cronk · 05/22/21

Glad you found a solution. Thank you for contributing to the Community.

Mark

Best Answer