check a box after 24 hrs

Question

I have a box that I would like to have checked 24 hours after my date field "Sent to Sales" is filled. Can anyone help with this formula?

Thank you,

Brandy

------------------------------
Brandy Nunes
------------------------------

markshnier__you · Answer

By 24 hours do you really mean the next day after the [Sent to Sales]

if so, then it will just be

IF(Today() > [Sent to Sales], true)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

austink · Answer

For that comparison yes it needs to be just a date field.You could go by just date but then this may not do exactly 24 hours. Say a person entered a record at night today and then went to the report tomorrow, if you just go by the date and not the time then that record would be checked the next day even if it was only about 12 hours away. If that is okay then this would work.Either way this is the way I would personally attack this. This ensures it is 24 hours after the fact and no sooner. This assumes [Sent to Sales] is Date/Time.if(Now() - [Sent to Sales] &gt; Hours(24), true)

austink · Answer

Does the checkbox need to trigger anything itself right when it becomes checked like an automation or can it just be checked on the record after 24 hours and then it triggers form rules or something else when a user next interacts with the record?

brandynunes1 · Answer

I want to use the check box as part of a formula for color coding.------------------------------Brandy Nunes------------------------------

brandynunes1 · Answer

I do have two boxes, one for 24 hours and one for 48.&nbsp;is it possible to do something that says the following for one box:IF(Today()-1Day = [Sent to Sales], true)and the following for the 48 hrsIF(Today()-2Day = [Sent to Sales], true)------------------------------Brandy Nunes------------------------------

Forum Discussion

check a box after 24 hrs

7 Replies

Related Content

Working with %%rid%% and checking a box

Verification that all boxes on a multi-select list are checked

Autofill user field when a checkbox is checked

Fill in date check box is checked

Check Box to create a Kanban Card

Recent Discussions

Many to Many too Many...

Are all QB notifications "No-Reply" emails

Bulk create child records from selection list

Selecting which fields to display from Formula URL searches

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting