Apr 02, 2024 09:56 PM
Hello all 🙂 I've been staring at this and I am sure it is right in front of me but can't see it. I have a table of scenes that have their filming date defined by a lookup field (I link backwards for print result purposes - if you have seen my other posts DocsAutomator saved my sanity)
Now the problem is of course that the linked filed doesn't ACT like one, so I cannot sort properly by date. I can group all the same dates together but they sort alphabetically, not chronologically.
How do I accomplish this?
Solved! Go to Solution.
Apr 02, 2024 11:23 PM - edited Apr 02, 2024 11:24 PM
Hello @Shannon_Bradley
Possible Solution:
The solution is if data comes from another table use the Lookup field and then sort it.
If data is on the same table then use the formula to create the proper date and then sort it.
My issue and solution:
I've also got this same issue. When I need to extract the month(using a formula) from the date then group it by month. It automatically sorts alphabetically, I've used have dropdown(single select) of the month and then sorted by it. The single select month is updated via Automation when that specific date-related field(s) are updated.
👍
Apr 02, 2024 11:23 PM - edited Apr 02, 2024 11:24 PM
Hello @Shannon_Bradley
Possible Solution:
The solution is if data comes from another table use the Lookup field and then sort it.
If data is on the same table then use the formula to create the proper date and then sort it.
My issue and solution:
I've also got this same issue. When I need to extract the month(using a formula) from the date then group it by month. It automatically sorts alphabetically, I've used have dropdown(single select) of the month and then sorted by it. The single select month is updated via Automation when that specific date-related field(s) are updated.
👍
Apr 03, 2024 04:09 AM
Yeap, can confirm that adding a lookup field to display the same field and then sorting by that like @dilipborad said works
Apr 03, 2024 10:01 AM
So simple! Thank you so much!