Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

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.