Skip to Main Content
Status Future consideration
Categories Releases
Created by Guest
Created on Apr 14, 2021
Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit A-I-15957 New Custom Field Type - Calculated Field.

Custom fields from calculation Merged

As a product manager, I want to be able to control the granularity of the external release date without having to specify the date separately from the internal release date.


I want to be able to configure a single date field for the ETA and then just control the granularity of that date field for the external date. To do this, I've added a custom field called "External Release Date Granularity" and a calculated column on a report to show the external release date (see screenshot).


What I'd like is to just add this field to the release layout as a calculated value which can then be used in reports without having to add the column everywhere.


Calculation

switch(field("External Release Date Granularity"), "Month", dateformat(field("Release date"), "%B %Y"),"Same as Release Date", dateformat(field("Release date"),"%d %b, %Y"),"Half", if(quarter(field("Release date"))<=2, dateformat(field("Release date"),"1H %Y"), dateformat(field("Release date"), "2H %Y")),"Quarter","Q" + dateformat(field("Release date"), "Q %Y"),"Early/Mid/Late Month",if(day(field("Release date")) <=10, "Early " + dateformat(field("Release date"), "%B %Y"),if(day(field("Release date")) <= 18, "Mid " + dateformat(field("Release date"), "%B %Y"), "Late " + dateformat(field("Release date"), "%B %Y"))))