Help

Re: Set Up Grid View By Groups: 1 Group for records dated in the future, 1 group for records in the

565 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Eskin
6 - Interface Innovator
6 - Interface Innovator

I have a grid view in my base shared with a specific group of people, it includes all records with a date/time within five days in the future AND all records in the past.

For easy viewing and sorting, is it possible to group the records into two groups:

Group 1: all records dated for today and five days in the future

Group 2: all records to date before today.

Is this possible?

3 Replies 3
TheTimeSavingCo
17 - Neptune
17 - Neptune

Yeap, you could do this with a formula field like so:

 

 

IF(
  DATETIME_DIFF(TODAY(), {Date}, 'days') > 0,
  "Before",
  IF(
    DATETIME_DIFF(TODAY(), {Date}, 'days') > -5,
    "Within 5 days"
  )
)

 

Screenshot 2023-05-15 at 3.33.45 PM.png

 

Jason_Eskin
6 - Interface Innovator
6 - Interface Innovator

Thanks so much Adam, this looks like what I'd want. Sorry for the 'beginner' question, but how do I deploy this formula in the Grid?

Ah, add a formula field, and then copy and paste the formula into it.  You'll need to modify the formula to point at the correct field though, specifically you'd probably need to modify the value {Date}.

If you could provide a screenshot of your current table with the date field I could provide you with the modified script right quick too