Help

Multiple Task Completion

Topic Labels: Formulas
Solved
Jump to Solution
441 1
cancel
Showing results for 
Search instead for 
Did you mean: 
rbn
4 - Data Explorer
4 - Data Explorer

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.

rbn_1-1676474798486.png

Thank you!

1 Solution

Accepted Solutions
Jack_Manuel
7 - App Architect
7 - App Architect

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'"

See Solution in Thread

1 Reply 1
Jack_Manuel
7 - App Architect
7 - App Architect

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'"