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
Im trying to create a formula that will show the days over due or highlight over due if a date is not filled in....
Angela Bowman
07-12-2017 11:02
Im trying to create a formula that will show the days over due if a date is not filled in. For my formula, ...
John Thomas
07-12-2017 11:34
Insert the below formula to the formula text field If(IsNull([Date of Petition]) and ToDays(Today() ...
Angela Bowman
07-12-2017 11:53
Perfect. Thank you John. If I wanted the text Overdue to be red and bold, where would I add the HTML ...
John Thomas
07-12-2017 11:56
If(IsNull([Date of Petition]) and ToDays(Today() - [Date of Death]) >=30 , "<span style=\"color:#ff0707; ...
Angela Bowman
07-12-2017 14:50
Thank you! Works Perfect!
1.
Im trying to create a formula that will show the days over due or highlight over due if a date is not filled in....
1
Like
Angela Bowman
Posted 07-12-2017 11:02
Reply
Reply Privately
Options Dropdown
Im trying to create a formula that will show the days over due if a date is not filled in. For my formula, I have a Date of Death field and a Date Petition was Filed. If it has been 30 days since the date of death and no date is put into the date petition is field, I want the task to show as overdue. Any Thoughts?
2.
RE: Im trying to create a formula that will show the days over due or highlight over due if a date is not filled in....
0
Like
John Thomas
Posted 07-12-2017 11:34
Reply
Reply Privately
Options Dropdown
Insert the below formula to the formula text field
If(IsNull([Date of Petition]) and ToDays(Today() - [Date of Death]) >=30 , "Overdue" )
I hope this will solve your issue!!!
3.
RE: Im trying to create a formula that will show the days over due or highlight over due if a date is not filled in....
0
Like
Angela Bowman
Posted 07-12-2017 11:53
Reply
Reply Privately
Options Dropdown
Perfect. Thank you John. If I wanted the text Overdue to be red and bold, where would I add the HTML into the formula?
4.
RE: Im trying to create a formula that will show the days over due or highlight over due if a date is not filled in....
0
Like
John Thomas
Posted 07-12-2017 11:56
Reply
Reply Privately
Options Dropdown
If(IsNull([Date of Petition]) and ToDays(Today() - [Date of Death]) >=30 , "<span style=\"color:#ff0707; font-weight:bold\">"&"OverDue"&"</span>" )
Ensure that you made the html tags as allowed
Is it fine? :)
5.
RE: Im trying to create a formula that will show the days over due or highlight over due if a date is not filled in....
0
Like
Angela Bowman
Posted 07-12-2017 14:50
Reply
Reply Privately
Options Dropdown
Thank you! Works Perfect!
×
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