Relative Parent Function

I have an estimate sheet that has different parent categories "rows". Under these rows we have different child rows that contain products "child rows". The parent category has a check box that if active the child rows will multiply two cells in the same child row. Unfortunately I don't want to use the specific cell reference since this order sheet is constantly changing based on the different products we have available.

I'd like to dynamically have a formula that calls the parent row and checks the value of the checkbox column and if true executes the multiplication of the cells in the child row. I've tried doing this with the "parent()" function but no luck and I have no other ideas on how to get this done.

All help is greatly appreciated. :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!