Help

Formula: add number of keywords

2047 4
cancel
Showing results for 
Search instead for 
Did you mean: 
hayley_coneill
5 - Automation Enthusiast
5 - Automation Enthusiast

I want a formula to add up the number of times a status is set to “Done” in multiple columns. Is this possible?
status.JPG

4 Replies 4

If you want to know when is complete, you can use IF(AND(Field1, Field2, Field3), 'Complete','Incomplete').

Also check this: Formula to add up items that appear in columns

hayley_coneill
5 - Automation Enthusiast
5 - Automation Enthusiast

To be a little more specific, I need a numerical value equal to the number of “done” status there are in a row.
status.JPG

0 + 
IF(Model = "Done", 1, 0) +
IF(Texture = "Done", 1, 0) +
IF(Animation = "Done", 1, 0)
hayley_coneill
5 - Automation Enthusiast
5 - Automation Enthusiast

@ Jeremy_Oglesby
That worked! Looks like when I tried to do something similar my formatting was wrong. Thank you!