Whew! I think that did it. Seems so simple now.
Original Message:
Sent: 03-16-2023 18:13
From: Mark Shnier (Your Quickbase Coach)
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
Try this
[TO BE BILLED BY] < =Today()-Days(11)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 03-16-2023 18:09
From: BuildPro
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
Great..
If TO BE BILLED BY is 11 or more days in the past (from today), checkbox needs to be checked
------------------------------
BuildPro
Original Message:
Sent: 03-16-2023 18:04
From: Mark Shnier (Your Quickbase Coach)
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
If you can say in words what you want, then I can help with the formula.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 03-16-2023 17:44
From: BuildPro
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
Maybe it should be
[TO BE BILLED BY] < =(Today()+Days(11)),true,false)
less than
------------------------------
BuildPro
Original Message:
Sent: 03-16-2023 17:40
From: BuildPro
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
------------------------------
BuildPro
Original Message:
Sent: 03-16-2023 16:26
From: Mark Shnier (Your Quickbase Coach)
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
The pretty simple formula so it certainly should work.
Can you prove with a screenshot on a particular record or on a report that it is not working? i.e. show me a screenshot where the [TO BE BILLED BY:] is more than 11 days in the future so after say March 29th and the checkbox is not checked?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 03-16-2023 15:57
From: BuildPro
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
FYI
[TO BE BILLED BY:] is a date forumla field
[CURRENT SCHEDULE DATE]+Days(6)
------------------------------
BuildPro
Original Message:
Sent: 03-16-2023 15:54
From: BuildPro
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
The checkbox is not being checked
thx
------------------------------
BuildPro
Original Message:
Sent: 03-16-2023 15:49
From: Mark Shnier (Your Quickbase Coach)
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
Can you explain what is not working? What is the symptom of the problem?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 03-16-2023 15:43
From: BuildPro
Subject: CHECKBOX BASED ON DATE FIELD + days formula assistance
checkbox [WARRANTY BILLING]
=
If(
[TO BE BILLED BY:]>(Today()+Days(11)),true,false)
is not working...
thank you
------------------------------
BuildPro
------------------------------