Forum Discussion
Solved
Token then expected
Hi all, I'm getting a bit confused with this IF formula: if [Completion Date] < [#"Month/Year"] and [Status] = Requested and [Status] = In Progress and [Status] = Approved by Management then ...
Hi Werfuks
if can handle whatever you throw at it.
What are Requested and In Progress ? Variables? If it's just text, which is what it looks like, you'd have to use
"Requested" and "In Progress". Same for Approved
if [Completion Date] < [#"Month/Year"] and [Status] = "Requested" and [Status] = "In Progress" and [Status] = "Approved" by Management then "Overdue" else ""Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
You have to enclose the text values in double quotes, like [Satus] = "Requested" and ...
Bur are you sure that "and" is appropriate? How is [Status] going to = "Requested" AND "In Progress" AND "Approved by Management"? The if statement evaluates to true or false per row, so the [Status] will be just one thing, not one thing AND another thing.
--Nate
Many thanks to you guys. With the double quotes it works now!