IF Formula - If Multiple Select Field = x, then status = "y"

I’m not clear what constitutes a completed task. Is it when Visibility Status is empty?

Could you write out your if statement in conversational English using the actual field names?

Something like:

If Visibility Due is in the past and Visibility Status is empty, then make Status "Complete"
If Visibility Due is in the past and Visibility Status is not empty, then make Status "Overdue"
otherwise if Visibility Status is not empty, make status “In Progress”

Thanks for getting back to me, sorry about the confusion. In conversational english, it would essentially be,

if Visibility Due is in the past, and all Visibility Status options are selected, then make status 'complete’
If Visibility Due is in the past, and not all Visibility Status options are selected, then make status "Overdue"
otherwise if not all Visibility Status options are selected, make status "In Progress"
if all Visibility Status options are selected, make status “complete”

I’m assuming I’d probably have to write the name of each Visibility Status option in the IF formula, maybe not. But I guess this was my original question. Is the way I’m envisioning it with the multiple selection field possible?

This should work for you.

Unfortunately, the COUNT function only seems to work on linked records, not multiple selects so rather than counting the total number of items, we have to search for each one individually to ensure they’re all present.

IF(
	AND(
		FIND("Detached Event Description",{Visibility Status}),
		FIND("External/Internal Contact Info",{Visibility Status})
	),
	"Complete",
	IF(
		IS_AFTER(TODAY(),{Visibility Due}),
		"Overdue",
		"In Progress"
	)
)

IF(
	AND(
		FIND("Detached Event Description",{Visibility Status}),
		FIND("External/Internal Contact Info",{Visibility Status})
	),
	"Complete",
	IF(
		IS_AFTER(TODAY(),{Visibility Due}),
		"Overdue",
		"In Progress"
	)
)

Worked like a charm! Thank you!