Jump to content

Conditional Formating based on two factors


This topic is 2888 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I want to highlight all overdue invoices in my database with conditional formating.

Currently the conditional formating created works but it works for all records. I want it to work for just records with the "P_Status = Complete/invoice"

 

I am thinking I need an if statement inside an if statement but cannot seem to get it to work.

any help appreciated.

Thanks in advance.

Link to comment
Share on other sites

Sorry I should have included that.

Here is what I am currently trying to get to work:

If ( Projects::P_Status = "COMPLETE/INVOICED";
If (Get ( CurrentDate ) ≥ Invoices::Date Created+Int ( 30 ); "");"")

 

When I do this all is clear. If I get rid of the first if then my conditional formating works but it works for all records not just the COMPLETE/INVOICED.

 

Hope this makes sense

Link to comment
Share on other sites

I'm a bit of a novice, but I thought that separate conditions worked as ORs.

I reckon you'll need to do something like

Projects: :tongue:_Status = "COMPLETE/INVOICED" AND ( CurrentDate ) ≥ Invoices::Date Created+Int ( 30 ); "");"")

in the same condition.

But.... remember 'm a novice!!!! :-))

Link to comment
Share on other sites

How about:

Projects:_Status = "COMPLETE/INVOICED"
and
Get (CurrentDate) ≥ Invoices::Date Created + 30

Note:

  1. You don't need to use the If() function here, because there's no "then";  the condition is either true (apply formatting) or false (don't);
  2. 30 already is an integer.
  • Like 1
Link to comment
Share on other sites

:jester:  I like that Mike!

 

Another reason for using the Code button when pasting scripts and calculations ... what shows up in people's emails drops everything after a open bracket '[' (or at least it did in calculations).  Many times people use their email as the response they receive and don't come back to the forum to see that what exists on the post is quite different than their email.

Link to comment
Share on other sites

This topic is 2888 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.