Forum Discussion
Please help with calculated column (If statements)
Hi, posting this again as I don’t think my previous post was clear. I’m trying to create a column to determine if an order has been shipped on time. An order is considered to be shipped on time...
eliasayyy
Memorable Member
Memorable Memberpelase try
on time?column =
SWITCH(
TRUE(),
AND(OOR[isShipped]=TRUE(),OOR[Original Ship Date] <= OOR[Current Ship Date] + 3),"Yes","No")
if i didnt understand your question , can you please be more specific on what your goal is and waht column we should look at?
Hi, not quite but your code gave me a hint as to how I could calculate what was needed, and have now managed to solve it using switch statements. Thank you! 🙂