This works great, and thank you for the Grouping on a date range article, @Katherine_Duh! I think a nice extension to this is to have a way to still sort in chronological order while being able to use the month common name (“MMMM”) instead of the mon...

Whichever field in the campgrounds table that links back to the trips table is that one that you will use in the first dropdown of the Lookup field configuration. Here is my quick mockup of what I think your campgrounds tables looks like: And here i...

The field must be included in the table for it to be available to sort with. In that case, add a new field to your campgrounds table and use the Lookup field type to link it to the date field from the trips table. This field will be automatically po...

Hey @Carlos_Gonzalez, I used REPLACE() instead of MID() and have it working. Using FIND() to get the starting index of the first hyphen and then replacing the middle date part with a zero length string (""). REPLACE({Full Code}, FIND("-", {Full Code...

@Conrad_Lindes are you thinking like Excel where you grab the corner of the populated cell and drag it across empty ones in the column and it will intelligently autofill values but adding 1 to the numbers or date? Cause I was looking for that as wel...