Auto Date updating a published report of Events List

Bob Payton

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?

Travis

You could build a formula that will uncheck the box when the event date is in the past, but there would need to be some logic that would check the box. Is there something in your row that designates if a row is for internal purposes only? 

Bob Payton

I was using this checkbox column for "internal purposes" and that is why I didn't want it to check based on a formula, only uncheck.  If that is not possible, I guess I could filter inclusion in the report on another manual checked column, then use this formula driven column only for deleting once the date is past??

Travis

Bob, how about this... check the boxes of all the rows you want included, then in your report set the criteria to show all rows that have the box checked AND the event date is in the future. Now, the report will only show tasks where the event date is in the future and the box is checked. 

Bob Payton

Makes total sense and a heck of a lot easier.  Thanks!

Travis

Glad I could help!