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!
Page 1 / 1
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'"
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.