Formula problem

eatonbp

Hi! Before I start, I want to say that I'm still fairly new with formulas, so it's very very possible that this error just might need a slight fix, but I need a bit more assistance with what I'm specifically doing wrong here to get a better grasp of formulas.

I'm trying to get a sum of how many tasks my vendor has completed, and it's under the column 'Project Risk', and it's a traffic light symbol system. I would like my final answer to populate in a previous column named: 'Formula' and for it to only show in the 49th row of this column. My arguement is as this:

=SUMIF([Project at Risk]1:[Project at Risk]49, "Green", Formula49)

I keep getting an 'INCORRECT ARGUEMENT' and I'm not sure what I'm doing wrong. Does anyone mind assisting?

=Chris Palmer

https://community.smartsheet.com/discussion/comment/465038#Comment_465038

Awesome! Happy this worked for you.
If you could mark me as the best answer I can get more kudos :-)

Matt Lynn-PCG

@eatonbp I think you're close. Remove the Formula49 part at the end. Also usually your range isn't just limited to row 1 through row 49 but maybe?
One of these two should work:
=SUMIF([Project at Risk]1:[Project at Risk]49, "Green")

=SUMIF([Project at Risk]:[Project at Risk], "Green")

=Chris Palmer

Hello @eatonbp

Consider trying something like this:
=COUNTIF([Project Risk]1:[Project Risk]48, "Green")

If the formula is in row 49, I put 48 to eliminate the overlap.

Let me know if that works for you, if you're still having issues screen shots would be most helpful to get a visual of what you're looking at.

eatonbp

https://community.smartsheet.com/discussion/comment/465034#Comment_465034

Thank you so much! So, this worked, however, I'm getting a 0 when I have around 30 green lights. How should I proceed?

eatonbp

https://community.smartsheet.com/discussion/comment/465035#Comment_465035

PERFECT! This worked, thank you!

=Chris Palmer

https://community.smartsheet.com/discussion/comment/465038#Comment_465038

Awesome! Happy this worked for you.
If you could mark me as the best answer I can get more kudos :-)