Smartsheet Summary RYG across multiple sheets/cells
I want to provide an overall RYG status tied to multiple sheets.
What is the best reference for determining the formula to do so?
Best Answer
-
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.
https://m.youtube.com/watch?v=eR8IRHTpXos
The Smatsheet formula reference is: https://help.smartsheet.com/functions
Good luck.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
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.
https://m.youtube.com/watch?v=eR8IRHTpXos
The Smatsheet formula reference is: https://help.smartsheet.com/functions
Good luck.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thank you Mark!
-
Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!