To be clear, these fields are Date fields. Not sure if "Issue" can show up in those fields but anyway that they can be identified and sorted would suffice.
I created separate "Issue" fields for all areas of concern and used the if empty them "Issue" deal. However, what I need it to be is if Empty equal to or greater than 3 days after field Measure Request Date, then "Issue". Can't figure that out. Please help. Thanks.
Here is what I have - If (IsEmpty(Measure Date); "Issue"; "")
So "Issue" shows up when Measure Date is Empty but I need that to be if Measure Date is Empty 3 or more days after Measure Request Date.
Please help. Thanks.
If (IsEmpty(Measure Date) or Measure Date > ( Measure Request Date + 3 ) ; "Issue"; "")
These fields must be true date fields and not dates entered into text fields.
Thank you! They are date fields. That needs to be if Measure Date is Empty AND it's past 3 days or more. Just change OR to AND?
So if it's only been 2 days since Measure Request Date, no "Issue" . Thanks again.
Sorry man, and if the Measure Request Date is Empty, no Issue with the Measure Date being empty for a job.
Try this calculation in an Unstored Calculation field:
If ( ( IsEmpty(Measure Date) And Get ( CurrentDate ) > ( Measure Request Date + 3 ) ) or Measure Date > ( Measure Request Date + 3 ) ; "Issue"; "")
A similar calc can also be used for a conditional format expression on "Issue" added to the layout as layout text to make the word "Issue" appear/disappear instead of using a calculation field.
Wow man, that worked perfectly. Sure do appreciate all your help. I'm learning a bunch. Thanks.
Phil, the way that is working is such that if the Measure Request Date has not been populated, it creates an Issue. I need it set so that if we have a job but we have not even received the customer's Measure Request and therefore no date, we do not have an Issue yet.
I also have Arrival Date and then Install Date. These happen weeks after the Measure so if there isn't yet an Arrival Date, I can't have an Issue with the Install Date.
Hope I articulated that properly. Can that work?
Attached is a picture of what I am seeing. Need for Issue to show up X number of days after Request for Measure is filled in, and not until that field is filled in. And then, I'd like it to go away after Measure Date has been filled in and thereby not an Issue anymore. Thank you.
Phil, the way that is working is such that if the Measure Request Date has not been populated, it creates an Issue.
Not quite. You shouldn't see "Issue" until today's date is 3 or more days past the request date. If Measure request date has not been populated with a date, then "Issue" should not appear. In your screen shot, there's a request date at least 3 days older than the meaure date in each record shown.
Need for Issue to show up X number of days after Request for Measure is filled in, and not until that field is filled in. And then, I'd like it to go away after Measure Date has been filled in and thereby not an Issue anymore.
Specifies a different result than what I understood you to want from your earlier posts.
If ( Not IsEmpty ( Measure Date ) and ( Measure Request Date > ( Get ( CurrentDate ) + 3 ) ) ; "Issue" )
Make sure that your calculation field is set in storage options to be unstored or this will not update with each new day's date.
I certainly may not have explained it properly. IF the Measure Request Date IS populated AND the Measure Date is Empty 3 days after the date in the Measure Request Date field = Issue. Once the Measure Date has been populated (no matter what it is) = no Issue.
It would seem that the above may not do that since CurrentDate is involved unless my logic is not correct. It seems that CurrentDate is not a factor but the Measure Request Date date +3 is.
Thanks for the help and sorry for the confusion. I did not have the fields as unstored so I fixed that. Thanks.
Hey man, got it on the CurrentDate. If Today's date is 3+ days from Measure Request Date = Issue. Even with unstored, which I changed, the Issue still stays in the field after Measure Date field is populated.
Let me know what you think I need to do. Thanks!