Two formulas
Hey all  hoping you can help me with the formula below. Trying to combine two of them but keep getting an error.
=(COUNT({Ready for Migration Range 4})  (=SUM([Column5]27:[Column5]32)))
In the first section I'm doing a count, second one if summing a set of numbers and then subtracting the two values. Any guidance or help would be greatly appreciated. :)
Best Answer

No worries! :)
It's good to know that I'm not the only human helping out in the community! 😄
Answers

=COUNT({Ready for Migration Range 4})  SUM([Column5]27:[Column5]32)

To elaborate on l@123's answer, you had too many parenthesis and the wrong number of closing parenthesis. Smartsheet is REALLY particular with parenthesis and matching parenthesis.

Honestly even with the parenthesis used, while excessive, wouldn't have stopped this from working as they all match up. The equals sign before the sum is what stopped it, though I should have said that. My bad.

haha. yes that too. :) Good thing you spoke up! I was just trying to provide clarity but i clearly didn't look long enough.

Thank you for the clarification. The formula didn't generate an error now, but it's not calculating correctly. It's resulting in a "1" when it should be a "5".

Can you share a snip of the values in the columns? You can black out any sensitive information.

Sure, see below 

And what ranges are your references supposed to check? One is a different sheet reference, and the other is column5. I don't see either on your picture.
Did you mean:
=COUNT({Ready for Migration Range 4})  SUM([Total]27:[Total]32)

I think that's what i meant (or want to happen) but it gives me an error.

Try each part of the formula individually. Which one gives an error?
=COUNT({Ready for Migration Range 4})
=SUM([Total]27:[Total]32)

The formula works when broken up, but not when it's combined. Any ideas why?

What numbers are they producing? The sum should be 285 from your snip, what are you getting returned on the count?

Which error are you getting?

If I use this formula  =COUNT({Ready for Migration Range 4})  SUM([Total]27:[Total]32) I get the unparseable error.

Have you double checked the range {Ready for Migration Range 4}?
Place your cursor on this range then select "Edit Reference". Make sure that it is the correct range. Sometimes smartsheet will delete these ranges on creation.
Help Article Resources
Categories
Check out the Formula Handbook template!