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!
Solved
Multiple Task Completion
+1Best answer by Jack_Manuel
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'"
+18You 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'"
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.