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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!