Can I change case AFTER the cell is referenced?


Hello, I have a Master sheet with hospital unit names. Some of the names are all caps, and I wanted to change that to be first letter in caps only. The words themselves would be the same. Only the case would change from capital letters to normal letters. The cells where these unit names are are referenced in formulas. Will this be a problem if I change the case? Will changing the case (but not the words themselves) break the formulas?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!