Help with formula
dteter
✭
I have 3 sheets.
- Summary Sheet
- Sheet 1
- Sheet 2
I want to take a cell on sheet 1 * cell on sheet 2 and return it to a cell on the summary sheet.
I have done it in the past but something seems to have changed and now I can't figure it out. Should be simple!
Comments
-
There might be an easier way, but you can use a different function, like SUM to reference another sheet:
=SUM({Sheet 1 Range 1}, {Sheet 2 Range 1})
then use those references in your equation:
={Sheet 1 Range 1} * {Sheet 2 Range 1}
-
Thanks for the reply! I will give that a try.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives