Formula for Total Column
In our estimating sheet I'd like to have a locked formula that for parent rows it shows the sum of the children and on non-parent rows it shows the product of quantity*rate.
I'd like it to be one formula so that it can be locked on the column. Right now I have separate formula's that from time to time will be messed up and creates an issue.
Is this possible?
Answers
-
Something like this:
=IF(COUNT(CHILDREN()) > 0, SUM(CHILDREN()), Quantity@row * Rate@row)
-
If you have your formulas, just place them in the needed cells, then right click on the column header and select lock column. It will then lock the column from being able to be changed.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!