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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!