Check a box if multiple conditions are met
I am looking for a formula that is able to either check a box or just record a value "Ready to Send Out" if multiple conditions are met.
Within a sheet, I have multiple names that are contained in a column [Names], each name may appear in multiple rows, but they are unique names. There is also a [Task Complete] column that corresponds to a task. Once the name has all of it's task complete (on separate rows) I want every row for that name to be checked in a column [All Task Complete].
Is there any formula that could achieve this?
Thank you for the help!
Help Article Resources
Check out the Formula Handbook template!