Formula Date Calculations to Show up in Calendar View
A
Angela
My company uses click up to track products. Where they are in development and where they should be. We have a custom field column that calculates an ETD (estimated date of arrival) based on another date. But this formula date does not show up in a calendar view.
In calendar view it allows me to show custom date fields but not custom formula fields that display dates.
Having the ability to display those formula calculated dates would allow us to see when on our calendar our products are supposed to ship/be in warehouse/ when samples should be arriving ex..... all on one calendar.
I have included an image of the formula we have used to calculate a prediction date.
Thank-you!
Log In
Natalie Williams
It's incredible that this still isn't possible.
You can't even create an automation to set a date field using a formula field. And you can't even sort a list by a formula field that calculates a date. It's so limited.
Steven Haddock
Yes, this feature really is needed. These dates from formulas need to be more useable. For calendars, reports, and calculations etc. It needs to do better.
Philippe Feracci
In order to get any automation from dates formulas are a must and displying them in a calendar is crucial. Here are a few examples of this application : calculation of the next birthday for HR apps, calendars for next billing cycles based on specific conditions calculated in formulas, annual equipment maintenance calendar with period bound conditions and so much more ...
Feel free to reach out if you want us to show you all our apps.
Caroline Ginty
Merged in a post:
Allow formula generated dates to appear on calendar
Joanne Her
It would be great to have the option to put formula generated dates on to the calendar view. This is much needed for projects with multiple set dates to track (I work in real estate).
Also, having a formula that generates a date that is x-many days from start date. Not just workdays.
Caroline Ginty
Merged in a post:
Forumla date fields to calendar view
K
Kellen
In Calendar view I would like to have custom formula date fields show up.
I have many dates that are calculated automatically from other date fields. My issue is I need to be able to see these in the calendar view. However I am unable to select 'custom formula' fields from: Settings -> Date Custom Field as they do not show up here.
Caroline Ginty
Merged in a post:
Allow viewing of tasks in Calendar view by dates from formula Custom Fields
Jerson Andrew Mellizo
Enable adding formula Custom Fields that calculate dates when viewing tasks in Calendar view