Hi!
I need a formula so that if a date column is the next day, a box is checked. This is what I've started, but I can't figure out how to say- if the date is tomorrow...
=IF(date:date=????,(1))
Any ideas? Thanks!
Amy
In a checkbox column, this:
=[Date]@row = TODAY(1)
or
=IF([Date]@row = TODAY(1),1,0)
works
I hope this helps.
Craig
Hi Amy, One question. Are you wanting that checkbox to remain checked if the date exceeds tomorrow? For example, if I have a row and its checked because tomorrow is the due date. What do you want the checkbox to do when the date = today? Or what about if it exceeds the date, do you still want it checked?
IF so, you might consider:
=Date@row <= TODAY(1)
This will check the date in the row and compare it to today plus a day, and if the date is less then it will remain checked.
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
Desired result is to pull the Initiative Name where the Days to Due Date is the least (so, due the soonest); then to make an index for the Top 10 Initiatives Due Soonest Currently using this formula: =INDEX(COLLECT({Project Master - Initiative}, {Project Master - Days to Due}, MIN({Project Master - Days to Due})), 1) This…
