Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Quick Base University
Skip main navigation (Press Enter).
on this day
between these dates
Back to discussions
sort by most recent
sort by thread
I am trying to write a formula to turn items a color if they meet certain criteria. With our app, we...
np, IF("Task Name]="Design" and [Duration] > Days(2), "FFAEB9") // pink That formula above ass...
Posted 05-01-2019 17:55
I am trying to write a formula to turn items a color if they meet certain criteria. With our app, we have task lists that are on each Quick Base record. I have a report built that shows certain tasks and their current status and how long they have been in that status. I would like to alter the report so that when a duration (how long the task has been in that status) exceeds a set number, it turns that line red. There are multiple different tasks that show up on this report and each task would have a different set number so there will likely need to be several formulas.
This is the format (in layman's terms):
"if" the task name is Design "and" the Duration is greater than 2 days "then" turn red.
In this example, Design represents a task that is included in all versions of the task lists and Duration is a "Formula - Duration" field.
RE: Formula Help
Posted 05-01-2019 18:41
IF("Task Name]="Design" and [Duration] > Days(2), "FFAEB9") // pink
That formula above assumes that the field type for the duration is a duration field type. If it is numeric field type representing the number of days, then the formula would be
IF([Task name]="Design" and [Duration] > 2, "FFAEB9") // pink
You can use "red' for the color, but its such a dark red that you can barely
read the words. Laura ( another fine QSP) has a great tool to select colours here
you just put in the hex code for the color. I like to comment the color as who remembers that those codes mean when you go back later to edit it!!
The // at the start or anywhere in a formula line means that it's a comment and Quick Base will ignore for Syntax checking
Then if you have multiple criteria it would look like this
[Task name]="Design" and [Duration] > 2, "FFAEB9", // pink
[Task name]="Install" and [Duration] > 10, "FFAEB9", // pink
[Task name]="Invoice" and [Duration] > 1, "FFAEB9") // pink
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic