Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
I'm trying to create a report that colors a row red if a date field has a date past 9 days
John John
07-11-2017 21:00
I'm trying to create a report that colors a row red if a date field has a date past 9 days - If ([Date ...
MCF Neil
07-11-2017 21:36
if more than 9 days in the future: If ([Date Released for Inspection]> Today()+Days(9) , "red", ...
QuickBaseCoach Dev./Training
07-11-2017 22:19
John, you will find that red is too hard to read though. There is a great tool here out up by another ...
MCF Neil
07-11-2017 22:50
I like "pink", its a soft red that translates well to reports.
John John
07-12-2017 14:13
Thanks... the color was not so much the answer I need. I need the formula to make that happen when ...
Michael Barrow
07-13-2017 17:48
Very useful color selection tool - thanks Mark!
QuickBaseCoach Dev./Training
07-13-2017 17:59
Thx Laura :)
John John
07-13-2017 19:40
Thanks... the color was not so much the answer I need. I need the formula to make that happen when ...
1.
I'm trying to create a report that colors a row red if a date field has a date past 9 days
1
Like
John John
Posted 07-11-2017 21:00
Reply
Reply Privately
Options Dropdown
I'm trying to create a report that colors a row red if a date field has a date past 9 days - If ([Date Released for Inspection]> days+(9) ,"red","")
2.
RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days
0
Like
MCF Neil
Posted 07-11-2017 21:36
Reply
Reply Privately
Options Dropdown
if more than 9 days in the future:
If ([Date Released for Inspection]> Today()+Days(9) , "red", "")
if less than 9 days in the past:
If ([Date Released for Inspection]< Today()-Days(9) , "red", "")
3.
RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days
0
Like
QuickBaseCoach Dev./Training
Posted 07-11-2017 22:19
Reply
Reply Privately
Options Dropdown
John, you will find that red is too hard to read though.
There is a great tool here out up by another great QuickBase solution provide, Laura Hillier.
https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1
so instead of where you have red, you would put in the hex code like #E55451
4.
RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days
0
Like
MCF Neil
Posted 07-11-2017 22:50
Reply
Reply Privately
Options Dropdown
I like "pink", its a soft red that translates well to reports.
5.
RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days
0
Like
John John
Posted 07-12-2017 14:13
Reply
Reply Privately
Options Dropdown
Thanks... the color was not so much the answer I need. I need the formula to make that happen when the dated released for inspection is past 9 days.
Thank you
6.
RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days
0
Like
Michael Barrow
Posted 07-13-2017 17:48
Reply
Reply Privately
Options Dropdown
Very useful color selection tool - thanks Mark!
7.
RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days
0
Like
QuickBaseCoach Dev./Training
Posted 07-13-2017 17:59
Reply
Reply Privately
Options Dropdown
Thx Laura :)
8.
RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days
0
Like
John John
Posted 07-13-2017 19:40
Reply
Reply Privately
Options Dropdown
Thanks... the color was not so much the answer I need. I need the formula to make that happen when the dated released for inspection is past 9 days.
Thank you
×
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
Copyright . All rights reserved.
Powered by Higher Logic