Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

simple sumif formula not working

✭✭✭
edited 05/16/22 in Formulas and Functions

Hello,

I am doing a cross sheet formula with a SUMIF.

=SUMIF({CLONE BATCH ID}, [CLONE BATCH ID]@row, {CLONE CUT QTY})

I am repeating the formula I have used in other sheets. I re-watched the formulas video and am doing everything exactly a I should. Why am I still getting a zero for my answer. It is returning the number zero and not giving me an error message.

Thoughts?


Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions