TonyMiller
Qrew Member
Joined 4 years ago
User Profile
User Widgets
Contributions
Multiple Color-Coding Formula within a report
I'm trying to create a formula in a report to highlight certain colors based on proximity to a date. If([Escalation Date]<Today(),"red", [Escalation Date]>Today xxxxx,"Yellow") The xxxx is what I'm having issues with. I want the row in the report to highlight Yellow if Escalation Date is within 3 days of now. Example: If today is the 8th, and the Escalation Date is within 3 days, then highlight yellow. This is the current formula: If([Escalation Date]<Today(),"Red", [Escalation Date]>Today()+Days(3),"Yellow") The Red works as expected, but the Yellow highlights everything else. I just want it to highlight items within 3 days of Today. I hope that makes sense. ------------------------------ Tony Miller ------------------------------I need a trigger 30 minutes after a record is created
I have a need to set an alert/reminder/email (something) 30 minutes after the time a new record was created. Is that possible? Scenario: A record is created. If a checkbox isn't checked within 30 minutes of the time stamp, then I need some sort of alert. ------------------------------ Tony Miller ------------------------------Re: Formula Help
Thanks again Mark. That did work, but (due to my inability to ask clearly for what I need), it did not work as I was thinking it would. This is what I have (screenshot): I need the formula in I-INDOC Expiration Date to look for a date in I-INDOC Continuing Qual Date, first, if null, then look in I-INDOC Qualification Date. If a date is in I-INDOC Continuing Qual Date, then calculate on that date. Make sense? ------------------------------ Tony Miller ------------------------------Re: Formula Help
When I try to use the formula, Is says it's looking for more. If(not IsNull([I-INDOC Continuing Qual Date]),[I-INDOC Continuing Qual Date],(AdjustMonth([I-INDOC Qualification Date], 36)-Days(1)) It say it's expecting ), at the end ------------------------------ Tony Miller ------------------------------Formula Help
I'm attempting to write a formula where it looks for a date in "Date 1" and if there is a date, then do a calculation. If there is no date in "Date 1", then use "Date 2" and calculate. I want the AdjustMonth to look in [I-INDOC Continuing Qual Date] first. If no date is found, then use the [I-INDOC Qualification Date]. ------------------------------ Tony Miller ------------------------------
