We have a system for reviewing new tools where they are checked for meeting accessibility standards and security standards. These are two separate teams with different workflows. The integration team needs to know when a tool review is considered complete.
I have two columns; one for the accessibility phase, one for security phase. I'm trying to make a formula for overall review status. There are multiple decision statuses for each. I would like to make the formula display either "Awaiting Decision" or "Review Complete". Review Complete would show if both columns have a value that indicates a decision was made.
For example, for tool A, the accessibility status = Testing Not Required and security status = Complete, it should be marked Review Completed in the formula column.
For tool B, the accessibility status = Completed and security status = Intake, it should be marked as "Awaiting Decision".
I've tried a variety of IF(FIND( arrangements but I can't seem to get it right. I only saved the most recent attempt, which was more simplified than what I'd like, but I'm not sure where I went awry.
Any help would be extremely appreciated.
IF(
FIND(
'Completed',
{Accessibility Status Phase},
IF(
FIND(
'Completed',
{Security Campus Phase},
),
'Review Completed',
)
'Awaiting Decision'
)
'Awaiting Decision'
)