Reference cells in another sheet WITHOUT having to use named ranges

Options
Ed Rivis
Ed Rivis
edited 01/05/20 in Formulas and Functions

Hi -

can anyone tell me how to use the following formula on a *different* sheet than the columns referred to in the formula...

=SUMIF(MonthYear:MonthYear, FIND("19", @cell) > 0, [AW1]:[AW1])

(This formula works great when it's in the same sheet (A) as the one with columns name MonthYear and AW1, but I can't figure out how to make it work when I put it in another sheet (B).

I have tried putting the name of sheet A in curly braces... but not found a syntax that works?!

In Excel this would be easy... but SmartSheet has got me dumbfounded!

Thanks in advance,

Ed.

P.S. I don't want to use named ranges to refer to sheet A ... because the next thing I want to do is make the name of the column shown as 'AW1' a relative reference so I can do HLOOKUP.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!