Solved
Color coding formula
Hi,
I'm trying to color code a report depending on a couple different fields. My formula isn't working, but i'm not sure what i'm missing. Any help would be great.
Field 1: [All info task] : we want the record to be pink if it has a date.
Field 2: [internal due date] : we want the record to be pink if it doesn't have a date
Here's my formula
if(not isnull([all info task]) or [internal due date]= isnull, "#ff66ff")
)
------------------------------
Catelyn Atkinson
------------------------------
I'm trying to color code a report depending on a couple different fields. My formula isn't working, but i'm not sure what i'm missing. Any help would be great.
Field 1: [All info task] : we want the record to be pink if it has a date.
Field 2: [internal due date] : we want the record to be pink if it doesn't have a date
Here's my formula
if(not isnull([all info task]) or [internal due date]= isnull, "#ff66ff")
)
------------------------------
Catelyn Atkinson
------------------------------
- OK,try this
IF(not IsNull([all info task]) or IsNull([internal due date]), "#ff66ff")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------
