Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Referencing formula for other sheets?
Is it possible to build a formula that references other cells/sheets into a new sheet?
I am trying to create a sheet that would sum values from another sheet into a new one to build some stats. Because the source sheet is generated using the SmartSheet/JIRA connector rows are automatically and constantly being added, so I can't build formulas into that sheet. I'm looking for a way to tally from the source. Is this a possibility?
Comments
-
There currently isn't a way to do that between sheets. I have a potential idea you could try though.
You could try adding summary rows to the top (or bottom) depending on how Jira is adding new rows to your sheet. If new rows from JIRA appear at the top, then create some blank summary rows at the bottom of your sheet, or vice versa if that's how things are working. Those summary rows should be able to stay, and then you could do your formulas there within the sheet. if you need to get that data to another sheet, you could then cell link your formulas from the JIRA sheet into a new sheet.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives