Solved: Format Rule: If a condition is met then format - Page 2

lstephens · 04-29-2024 05:22 AM

I currently have a format rule that puts a red exclamation point next to the description in my table if [Date Approval Received] is +30 days.

This rule, however, needs a tweak for specific jobs with [Job Type] "PMs" so I duplicated the +30 rule and was going to add an additional condition to it like below

If [Job Type]="PMs"

TODAY()>[Mo PM Due]+30

This is not working, so I need help! I also came to the realization that my first rule will still trigger for PMs contradicting the second!!

Insite: When we receive approval for most jobs we want them done in 30 days but for PMs, we may receive the approval months before its actually due. I have a field [Mo PM Due] which is in date format so we can create the format rule on that.

Gianlucapozza

@lstephens wrote:
[Job Type]="Quoted Job", "Service", "PM Repairs", "Annual Discrepancy Repairs", "Verification", "Training";

Here it is. You can not compare in that way a column value to a list of values. Thing you can do is using the command IN(). Look for that

View solution in original post