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!
Help Article Resources
Check out the Formula Handbook template!