Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Date checkbox formula

edited 12/09/19 in Archived 2017 Posts

Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date.

So basically the test date less 365 days, and then checking if that date is within the current month (for example June 2017) it would be ticked.

I know I could introduce another column which takes the test date less 365 days, then the checkbox checks that column, but i'd rather not introduce yet another column.

Any ideas please??? 


  • Hello—

    I'm not exactly sure what you're wanting with the less 365 days part, are you just wanting to see if your test date is within the current month and current year?

    If that's the case, you might try placing a formula like the following in a checkbox column:

    =IF(AND(MONTH([Start Date]13) = MONTH(TODAY()), YEAR([Start Date]13) = YEAR(TODAY())), 1)

    Make sure to change the cell references to match the columns/rows in your own sheet. You're welcome to check out our functions list here: https://help.smartsheet.com/functions

    Let me know if that's not what you're wanting and maybe I can come up with another formula.

This discussion has been closed.