Creating Index for Unique Values
I am trying to create a formula that can be converted to a column formula but am having issues. I referred to https://community.smartsheet.com/discussion/54816/extracting-a-list-of-unique-values-from-a-list-on-another-sheet to come up with the formula to use, however it uses absolute references, which can't be made into column formulas.
What do I need to modify to allow this to work and become a column wide formula? My formula is:
=IF([Project Sum Hierarchy Helper]@row = 1, "", (IF(COUNTIFS([Job Name]$1:[Job Name]@row, [Job Name]@row) = 1, COUNTIFS([Job Name]$1:[Job Name]@row, OR(ISBLANK(@cell), NOT(ISBLANK(@cell)))))))
I added a bit to ignore parent rows, as the data I am trying to index are always child rows.