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"))))