Check a box if multiple conditions are met

Hi,


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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!