Change in status with one date - Flag

[EmaVasileva]

Hello team,

I have the following data coming directly from my client's system:

Order number	Status	StatusDate (m/d/y)
AB1	Closed	7/5/2023
AB2	In progress	7/6/2023
AB3	Open	7/7/2023

I need to add a new column with an indicator (Ok/Not OK) when the status is different than "Closed" and it hasn't been changed in the last 3 days. The problem here is that for every Order, the status&date are re-written when it happens, and there are no list of all dates during the proceess of status changing. I have only the date of the last change. 

Is there any way to get this additional column with current data or somehow to compare the statusdate with today, in order to see if there is a status change in the last 3 days?

Thank you.

[amitchandak · Accepted solution]

@EmaVasileva ,

new column

= Switch(True(),

[Status] <>"Closed" && [Status Date] >= today() -3 && & [Status Date] <= today(), "OK",

"No Ok"

)

Add more rules as per need