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.
Auto Date updating a published report of Events List
We have an a Smartsheet of Events - tradeshows etc that we will be participating in. While initially developed for internal sharing, I have added a "publish" checkmark column, with those items checked being part of a Report, which I then Publish to our public website.
I would like to include a formula in the checkmark column so that once the event date is past, it would "uncheck" the event, thus deleting it from the published report, but not deleting it from our list. Keep in mind I can not use this formula to automatically check all events in the present, as some events on our list are for internal purposes only.
Is there a formula to make this happen?