CALENDAR VIEW HELP
Is there a way that you can either hide or move to another sheet any information that is over 4 weeks old. What we are trying to do is make a calendar view for PTO requests, but we only want the current month and going forward. We don't want anything older than 1 month visible to anyone other than HR. I've tried using the automation, but i just can't figure it out. Maybe there is a formula?
Answers
-
Hi, I think there are a couple of ways to handle your question.
- You could create an automation to move rows to another sheet. For example, if your date is in the past, move to "archive" sheet.
- You could use a report to display your calendar (instead of the sheet) and filter the report to only display entries/items, "not in the past."
I am making assumptions about your data and that you have date columns to key off of to support either of the methods. I would consider trying out the report option first, as it may be easier.
I hope this helps. Good luck.
-
There will really be no information besides date and employee name with PTO request on that date. We just need to hide or delete anything older than 1 month old.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!