Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

How to GROUP a Custom Field

Avatar

Level 10

I created a calculated custom status timestamp field - to show when a project was changed into a particular status. This works great - see attached file. I am able to get the date to display, however, I can not manipulate the date.

However, I am not able to group the values. Meaning, I'd like to group for example, all may 2021 together, all May 2020 together ... group them by month... but I can't see how to group the results.

Thanks for any suggestions.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

4 Replies

Avatar

Community Advisor

what did you format your timestamp field as?

Avatar

Level 10

I got it formatted as "TEXT"....uggh ... what can I do about this? I need a fix....

Avatar

Community Advisor

there's no fix (unless the fix is that you learned your lesson! Which let me assure you, I make this mistake all the time so... 😂 ).

Just delete the field and create it all over again. Sorry!

Avatar

Level 10

I will create all new custom fields and format them as 'date' - thus I should not have this problem. Thank you for bringing the format type to my attention.