Formula
Options
Answers
-
It would be something like this:
=COUNTIFS([Assigned (Action Item#1)]:[Assigned (Action Item#1)], [Assigned (Action Item#1)]@row, [Status #1]:[Status #1], OR(@cell = "Completed", @cell = "Not Started", @cell = "In Progress"))
You can change this part after the 1st comma [Assigned (Action Item#1)]@row to just a person's name "Name" if that is easier.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!