Need Help with Formula Creation
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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!