Convert to Column Formula
Is there a work around for "Convert to Column Formula" in the Primary Column that has an hierarchy?
We love the hierarchy groupings and I do have a formula there that gives a sneak peak of the name and site assigned at first glance but it is cumbersome to go to the sheet to copy the formula down. I was hoping it could be automatic as I have a lot staff who are not comfortable with making this update. Are there any other options to make this easier for me so that my colleagues readily see this information?
Here's an example of what my sheet looks like and this is the formula used: =Last2 + ", " + First2 + "-" + Site2
Any help is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!