- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 15, 2023 07:32 AM
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! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 15, 2023 09:13 AM
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'"

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 15, 2023 09:13 AM
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'"
