More advanced functions in Formulas
Collecting various formulas request here related to more advanced function capabilities
Maybe this doesn't belong here, but color-coding to keep track of nested functions and error help when writing a long formula would be great. Right now I'm manually counting red ))))s... not a great UX 🤦🏻♂️
Lookup formulas would be great. Would have to think through how this would interact with Rollup fields, as they are somewhat similar for some use cases.
It would be good if formulas can handle time like estimates and time tracked and then compare it to custom fields (budget) to give flags and notifications.
Ability to use EXCEL like formulas to better integrate logic into dashboards and improve automation.
Somehow, many of us seek to replace Excel files with ClickUp, so we don't have to be working in several places at once. Clickup allows us to have everything in one place, well, that's what it should be, but if the formulas don't improve and there is total integration between formulas, custom fields and dashboards, then it doesn't make sense.
Ability to use other formula results fields in new formulas/fields.
Calculate totals of child rows in the parent row cell Sum[children] would be helpful like Smartshet has.
Ability to use calculated fields in alerts, filters and other actions
Ali İlhami Öztan
Formulas should work for custom fields and relational lookuo fields. This is a main functionality in Airtable and Notion. Clickup should add this immediately.
More fields, especially custom fields to be used in the Formula.