Hello,
My stakeholder wants to me to categorize content based on different statuses in two different columns. However, she wants one of the statuses to be associated with both categories. I’ve explained to her that I feel this is double counting, but she insists she needs the reporting this way.
This is what she wants:
- If ID Status = Booked and Status = Complete then the Category should be DONE
- If ID Status = Booked (regardless of the value of Status) then the Category should be COMPLETE
Do you know of a way that I can accomplish this?
Attached is a workbook with as far as I’ve gotten -- Booked values only show under DONE.
Thanks for any and all help,
Thomasine
Hi Thomasine,
This one picked my brain a bit It was good to note that Booked ID Status contains multiple Status values. I used a switch statement to evaluate the ID Status that you can add on to when you are determined other ID statuses. The nested if stated then evaluates the Status field for the 'Complete' status to mark is as 'DONE'; else 'COMPLETE'. Please let me know if this helps you in anyway.
[Category]
CASE [ID Status]
WHEN
'Booked'
THEN
(IF Status = 'Complete' THEN 'DONE' ELSE 'COMPLETE' END)
// Add additional conditional logic when other category types are defined
ELSE
'To Be Defined'
END
