We have great interest in being able to consolidate our departments by region. The department codes are random and subject to change of region so a range of departments or masking isn't an option. I thought to take advantage of pointing and clicking and using the sum of selected departments function under departmental comparatives in smartsheet, but it isn't working for me, the sum always ends up as 0. Has anyone had success with this - if I could figure out what the formula should look like I would happily hardcode it. Also, are there any plans, or is there a current function that will allow me to assign random departments to a summary... Hoping for advice...

Thank you.
Sandra