In this example, I have an events calendar. I created a view on the team's page to this calendar where I want to display an event until the date passes. When the date passes, the event will no longer be displayed. So, in order to have a filter on this event, I need a special calculated field/column.
Steps to create a calculated column:
1. Navigate to the view where you want to add your column.
2. Add column
3. Enter a name for the column (here, Display_Until)
4. Enter formula (here, =[Start Time])
5. Select Category from Insert Column box
6. Select data type (here, I selected Date and Time) which displays additional fields, select "Date Only"
7. Select "Ok" to save.
Now, you can add this newly created field to your filter.
No comments:
Post a Comment