JackWoods
4 years agoQrew Trainee
Color Format Formula
I'm trying to say if the task is overdue by more than 15 days AND it's NOT completed - please highlight the task in the report.
Case(true,
[Days Overdue]>=15 & [Status]!= "Complete" ,"#FFFFCC","")
it seems to be giving me the error of...
"the operator ">=" can't be applied to types number, text"
please advise :)
------------------------------
Jack Woods
------------------------------
Case(true,
[Days Overdue]>=15 & [Status]!= "Complete" ,"#FFFFCC","")
it seems to be giving me the error of...
"the operator ">=" can't be applied to types number, text"
please advise :)
------------------------------
Jack Woods
------------------------------