Dual Column Switch

PHOTO EMBED

Thu Oct 21 2021 00:46:19 GMT+0000 (Coordinated Universal Time)

Saved by @cnewnham #vba

Status - Action Revised = SWITCH(
    TRUE(),
    '2 Audits - Combined'[event status]="Complete" && '3 Actions - Combined - Audits'[# Days Completed Overdue]<=1, "Overdue",
    "Other"
)
content_copyCOPY