Check @Notion's Formula Capabilities in Tables. I have migrated from Notion to Clickup and this is literally the only feature not allowing me to close the Notion account.

Being able to sum-up values from subtasks into a total value for each parent task

The similar "column-sum" functionality is too basic/limiting, and does not serve purposes of calculation and reporting.

Hi Voters! Thanks for your engagement on this Feature Request. We are currently scoping upcoming enhancements to the Formulas feature, and have a quick survey to get some additional information from you on how you are using Formulas today. Should take no longer than 3-5 minutes. Thanks in advance!

Being able to do formulas for weeks would be extremely helpful!

The formula function is quite difficult to use compared to competing tools. It's not user-friendly, has limited features, and only allows numbers (with no font customization).

Have a formula for automation start and due dates

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.