This topic is in two parts
- Show Event Names By Type On A Weekly Calendar
- Automatically Remove Rows Based On Today’s Date
Show Event Names By Type On A Weekly Calendar
I have a table called Events with an Event Name, Event Date and Event Type (Holiday, Client, Celebration, Conference)
I have another table called Calendar where I show the current week number. This helps our team stay focused on what’s upcoming especially when we may have a Conference, Client Event or Celebration to plan for.
SCENARIO: How do I related Table(Events) as a lookup field or formula to Table(Calendar) so that the Event Name will show up in the proper week?