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

→