Multiple Task Completion

[rbn]

I have three training sessions, and participants need to have completed all three in order to proceed. I'd like to have a formula that shows 'completed' when all three = completed and 'incomplete' when none/not all are complete.

Thank you!

[Jack_Manuel · Accepted solution]

You could try something like,

IF(
  AND(
    {Training Session 1} = 'Completed',
    {Training Session 2} = 'Completed',
    {Training Session 3} = 'Completed'
  ),
  'completed',
  'incomplete'
)

This saying , "If everything inside AND() is true then say "complete", otherwise say 'incomplete'"