Cross sheet formula
I am new to Smartsheet and am struggling with a basic formula.
I am simply trying to multiply a value from in a specific cell from one sheet with a value in a specific cell from another sheet.
I have been able to get a result by using this formula. =$[2021 WP Year-End Forecast]1 * ({Project Costs - Cost - Labor OT (107215)}), however when I change the value in the 2nd sheet, the formula does not update the value in the first sheet.
Any suggestions would be appreciated.
Thank you.
Best Answer
-
Hi Paul,
Thanks for responding. I was able to figure this out and is now working.
Answers
-
HOw exactly are you creating your cross sheet reference, and what exactly are you referencing?
-
Hi Paul,
Thanks for responding. I was able to figure this out and is now working.
Help Article Resources
Categories
Check out the Formula Handbook template!