Need Help with Formula Creation
![Felicia Nabors](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi,
I am creating a metrics sheet for dashboard data. I need to create a formula that is using a reference sheet across two columns. One column in the source sheet is a name, but the second column is time. I want to do a (if name equals, then sum time for the name) formula.
If I wanted to put the formula is my source data sheet it would be =SUMIF([Researcher]:[Researcher], "FN", [Time spent | .1=6 minutes, .5=30 minutes]:[Time spent | .1=6 minutes, .5=30 minutes]).
Thank you in advance for any help.
Best Answer
-
1.Paste the formula that you have into the sheet you want it to be on (new sheet).
2.Then, click on the cell you put it in and highlight the text that is currently the column reference.
3.The pop up window will give you the option to Reference Another Sheet.
4.Click there and follow the instructions.
4a.You will select your source sheet from the tree.
4b.Then, highlight the Researcher column.
4c.Then give that column a name.
5.Once you click OK you will return to the new sheet and the text you highlighted in step 2 will be replaced with the cross sheet name you entered in step 4c. It will have { and } around it.
6. Repeat for the [Time... column.
There are some online help guides here:
Answers
-
1.Paste the formula that you have into the sheet you want it to be on (new sheet).
2.Then, click on the cell you put it in and highlight the text that is currently the column reference.
3.The pop up window will give you the option to Reference Another Sheet.
4.Click there and follow the instructions.
4a.You will select your source sheet from the tree.
4b.Then, highlight the Researcher column.
4c.Then give that column a name.
5.Once you click OK you will return to the new sheet and the text you highlighted in step 2 will be replaced with the cross sheet name you entered in step 4c. It will have { and } around it.
6. Repeat for the [Time... column.
There are some online help guides here:
-
KPH thanks. When I tried that initially it failed for me, so I was obviously doing something wrong. It is working now.
-
Great! Enjoy your new dashboard when it's finished!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!