Formula and Response Question

Onita_B_OB1

I need a formula based off of two columns. Date Created and the Date Reported. I am trying to determine if individuals are submitting documents within 24 hours. If they are in another column it should populate "Compliant". But it seems to be working for some but not others and the dates are sometimes the exact same date. This is the formula I currently am working with. =If([created]@row<=[Date Grievance Received]@row,"Compliant"). I used< = as </=, which I was told was equivalent.

Brian_Richardson

Date Created captures the date that a row was created and won't update from that point forward. Is that what you intended?

How do you capture Date Reported / Date Grievance Received?

Just following the logic, Created date is always going to be before any other date that you capture through automation. You may want to use Modified date instead, or a couple of automations to capture dates on triggers and then compare them.