3.3k
Formula Column Calculations
planned
J
Josh Udell
It would be very nice for the Formula columns to be able to calculate at the bottom like other columns do.
Log In
Activity Feed
Sort by
T
Thomas Bull
This article is really amazing. Thanks for the sharing.
Caroline Ginty
Merged in a post:
Sum Numeric Columns
Pete Rakozy
If a custom field is a number or a formula, I'd like to be able to sum the entire column. For examp. We have one column that multiplies the time tracked by the value per hour (ie. 100/hr) and the column then calculates the total. (ie. 10 hrs x 100/hr = 1000) If we have 15 task we'd like to sum the entire column so we know what the total value is for all 15 task.
Caroline Ginty
Merged in a post:
Formula Custom Field with Calculated Sums/Range/Average
C
Christos Zantis
Use case scenario for e.g. Invoices
Invoice Amount (Manual)
VAT Rate (Manual or Single Select %)
VAT Value (Automatically Calculated [VAT Rate] * [Amount])
Total Invoice Amount (Automatically Calculated [Amount]+[VAT Value])
Total Invoice Amount could be rolled-up to give you a total of all invoices issued.
If you also have a Checkbox for Paid/Unpaid and use it to Filter, you could have an overview of Pending Invoices.
Caroline Ginty
Caroline Ginty
Merged in a post:
Calculations for Lists
Jack Young
I would really appreciate a permanent field for list formula column calculations. Each of our projects is a list with discrete tasks. At present, it is impossible for us to get a quick over-all view of the time spent as compared to the retainer we received. There are probably many different ways to arrange this, but column calculations for Lists that would enable us to set up a formula [(time tracked x hourly rate) - retainer amount] would be a start.
Caroline Ginty
Jeremy Van Caulart
Also, use formula columns in formula columns for calculations. Monday.com mastered this, ClickUp needs this basic/essential for sales teams feature.
Dr. Henry Kornegay
This is one of the best features on Monday.com. I hope this comes out soon
Tanner Wixom
This would make it much simpler to sum up calculated task-level billable amounts incurred against a monthly retainer. Please add this feature!
M
Mason Kirby
Thanks for the information.
Load More
→