0-30, 31-60, 61-90 Columns automated by formula (Checkbox)

I have a 3 column breakdown of 0-30, 31-60, 61-90 days and a want a formula to check the box between these based off the current dates listed for the task.

What I currently have is =IF([End Date]@row < (Today@row + 31), [End Date]@row >= Today@row), 1, 0) but receive an error when doing so. How can i get this to automatically check this box? and then check the box if it falls under one of the other categories?

Austin

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @Austin Probst

The formula needs an AND function

=IF(AND([End Date]@row < (Today@row + 31), [End Date]@row >= Today@row), 1)

If interested you can find more information here

https://help.smartsheet.com/function/and

Will this work for you?

Kelly

All comments

Kelly Moore

Hey @Austin Probst

The formula needs an AND function

=IF(AND([End Date]@row < (Today@row + 31), [End Date]@row >= Today@row), 1)

If interested you can find more information here

https://help.smartsheet.com/function/and

Will this work for you?

Kelly

Austin Probst

This worked! Thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.