Status formula based on date
Looking for assistance, and seems like the multiple variations I have tried are not producing the results. Here is what I am seeking accomplish:
[CRM Status] Cell for Results
If [74. Discharge date]@row is blank return "No Discharge"
If [74. Discharge date]@row is TODAY or equal to / less than 3 days from TODAY return “OK”
If [74. Discharge date]@row is more than 3 days from TODAY return “NEED”
IF[CRM Complete]@ row is checked return “OK”
Thank you in advance for your assistance!!!
Help Article Resources
Check out the Formula Handbook template!