getting a '1' or '0' based upon a date column and a condition column (Planned/Occurred)

[Anonymous]

Hi All,

I asked this recently in another post but the advised steps did not work,

I am looking to create a column based on the following two columns. I am trying to get any items listed as 'planned' in the 'Interaction column' but have past there 'date of interaction' date to show as a value (1) - I will refer to thesae values in this post as 'Overdue'. Items listed as planned that are still in the future would not show.

The resulting column would show a '1' for enteries not being overdue and a '1' being in place where the entries are overdue, likewise items not overdue (having been tagged as planned but where the date falls in the future) would show a '0' value.

I would appreciate any and all help 🙂

[sturlaws]

Hi @Anonymous 

Do you still have issues with this?

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Cheers,
Sturla

[Pete_MASS]

Hi, I've just done a very similar problem. My way may work for you. I made a new column 

CalDueStatus = IF([Calibration Due]>TODAY(), 1, 10)

I used 1 & 10 for testing. Then another column with conditional formating (as per attached) to get the RAG effect.

Gauge Inspection Due

Hope this helps.

[HotChilli]

If you post the data (not a picture) and show the desired output I am sure we can get this solved.

Can you also clarify this part "The resulting column would show a '1' for enteries not being overdue and a '1' being in place where the entries are overdue" -  this will get cleared up if you can show the column in your desired output.

I see the data in 3 categories:

Planned, earlier than today or today  --> Overdue so show 1

Planned, later than today --> 0

Occurred. --> 0

Is that right?