Allow adding "formula" custom field type to multiple locations
Rüdiger Biebl
Situation: Currently, there is no option to add a formula (custom field) to different locations (lists e.g.). The only way is to dublicate the formula in the new location.
Solution: Formula custom fields should be allowed to be added to different locations in the custom field manager.
Log In
Caroline Ginty
Merged in a post:
Ability to re-use Formula Custom Fields from the Custom Field Library
Mateusz Kruk
(User requested)
Formula Custom Fields don’t appear in the "Use field from library" feature where you can re-use existing Custom Fields in another Space/Folder/List.
Paola López Espinoza
Great importance and added value: cross-task field referencing. ClickUp can be seen as a spreadsheet where I store flat tables, such as the real use case where I need to pass table A and B as lists with separate tasks, where list A includes tasks of type A that relate to some tasks in list B. As in Excel, it is useful to use cross-references, in this case I only need to view the data from table A to use in the operation of list B, both being customized fields for each list, and therefore, independent in each list. Given the workflow, I require that this be maintained and I minimize the manual entry of information because several values will be populated and calculated automatically.
Sarah Wyatt
Caroline Ginty how can we access this other post 'Share Formula Custom Fields Across Locations'? Can you put a link here?
Caroline Ginty
Sarah Wyatt It was merged into this request, as they are one and the same, so the link now goes to this request.
Caroline Ginty
Merged in a post:
Share Formula Custom Fields Across Locations
Jessica Lee
Caroline Ginty
I'm going to merge this into our larger task for enabling formulas support in multiple locations as well.
Caroline Ginty
Thanks for this feedback Jessica Lee! While Formulas aren't supported in multiple locations today, you can create a Formula at the Folder, Space, or Workspace level if you want it to be available for all lists/tasks inside the given Folder, Space, etc.
M
Michele Alise
Upvote! I use a custom formula to calculate an earnings column (hours tracked x. hourly rate), which I pull into a dashboard so I can easily view running totals for the project. My idea was to have a high-level client dashboard to pull in all project totals, but now that I've configured each list and tested it, even though each list is checked in the data column, the calculations don't happen. The problem is that, because the custom formula is newly created for each list, the drop-down for the "measure" field shows each of these instances, and you can only select one. Too bad, this was an exciting possibility!
Caroline Ginty
Merged in a post:
Using formula in two different lists
Umit Gunes
We need to use formulas with custom fields in two different lists.
Caroline Ginty
Merged in a post:
Add formula across several lists (like any custom field)
Mara
Why isn't it possible to have a formula across several fields?
it can't be duplicated or add to another list. Even a duplicated list doesn't keep it...
It has to be done manually everytime... So tedious !
Caroline Ginty
Merged in a post:
using the same formula field located in multiple lists
Pip Kolmar
Apologies if this is repeated. I looked and I see similar posts but, but I specifically just want to solve the problem from my screenshot attached. If I could just use the same formula field across multiple lists, I could then roll them up in a report. All I'm trying to do is calculate the hours remaining for a scope across 2 lists which represent projects within that scope and then add them together in a dashboard so I can see total remaining hours easily. The fact that I can't is bonkers.
Load More
→