This is my first post to the community. I’ve seen other posts similar to this topic, but they don’t quite address what I’m trying to achieve.
I’m having an issue with a nested IF statement and not sure whether a combination SWITCH/IF would be best for this formula.
I have two columns - column 1 (Date) and column 2 (Location) that is single select. I want a third column (Status) that returns a value based on what is populated in the first two.
Logical Argument 1: If column 1 (Date) is not blank OR column 2 (Location) is ‘Outside Area’, the Status column should return “Yes”.
Logical Argument 2: If column 1 (Date) is blank the Status column should return “No”.
Any help would be greatly appreciated.