Formula Won't Stick in Cell


I have been using =[Director Name]@row to make a name transfer over instead of the email from contacts. I have several columns this way. I needed to add a new column and now the formula won't stick. If I tab over, it goes away, if I hit enter, it goes away. How do I make this formula stick in the cell so I can make it column formula? You will notice that I was able to get it to stick in the LC Assistant Approval Name column. Any help would be appreciated.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!