How would I skip parent rows in a column formula?

I want to use a column formula to track time spent on various tasks. Each task row would fall under various Parent categories. I have a start time and end time column, and time would only be entered in the Task row, not the Parent row.

I found an excellent (really long) formula to figure out the total time in a new column in an old Smartsheet community string. However, I want it to apply to the whole column - except for the Parent rows. What would I add to the formula in order to exclude the Parent rows?

Thanks, in advance, for any ideas!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!