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

Related Content

Formula URL Button to Open New Form and Check a Box

Nested API Button open form to add input, check box and redirect back to original form

Check box doesn't always show in my table

Working with %%rid%% and checking a box

Check one field for multiple conditions