Forum Discussion
MarkShnier__You
Qrew Legend
What field type is your due date field?
Can you post the formula you are using?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Can you post the formula you are using?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JeffPeterson1
4 years agoQrew Captain
It's a Datetime type field.
Here's the current formula:
If(
ToDate([Due Date]) > Today()+Days(1), "Orange",
ToDate([Due Date]) > Today()+Days(2), "Yellow",
ToDate([Due Date]) < Today(), "#ffcccb")
------------------------------
Jeff Peterson
------------------------------
Here's the current formula:
If(
ToDate([Due Date]) > Today()+Days(1), "Orange",
ToDate([Due Date]) > Today()+Days(2), "Yellow",
ToDate([Due Date]) < Today(), "#ffcccb")
------------------------------
Jeff Peterson
------------------------------
- MarkShnier__You4 years agoQrew LegendCan you post the error message you get when you try to save the formula? Does the formula save OK, if so nevermind the yellow warning icon.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------