Need Help with Formula Creation

Felicia Nabors · 02/05/24

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.

KPH · 02/05/24

Hi @Felicia Nabors

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:

https://help.smartsheet.com/learning-track/level-3-advanced-users/cross-sheet-formulas

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

KPH · 02/05/24