Formula with sheet reference use data from Row 1

DawnB

Hello, Smartsheet Community: I need help with a formula.

In my formula, I am referencing another sheet, but I need to always reference the top row of the sheet I'm referencing. How do I write my formula to always reference the top row? This is my current formula. Thank you

=SUM(([Nitrile Gloves - XL]@row) - ({UEM Safety Supplies Request Form NITRILE XL}))

DKazatsky2

Hi @DawnB,

When you create the reference, just choose the one cell you want as opposed to the entire column. Additionally, I do not think the =SUM formula is what you want, try the following.

=[Nitrile Gloves - XL]@row - {UEM Safety Supplies Request Form NITRILE XL}

**again, make this reference just the cell you want

Hope this helps,

Dave