Apply Formulas to ONLY grandchild cells in the primary column
Is this possible? I am looking for a way to automate a process for our team. I have a few columns that will provide a product name, project type and then the tactic name. The tactic name will always be equal to the Product name + the Project Type. Here are some examples with the current formula I am using (I have to add the " " since smartsheets won't add a space:
=[Product/Campaign/Sustained Marketing Name]@row + " " + [Project Type]
Is there a way to have this formula automatically populated every time a grandchild row is created?
Let me know if you need more details or if that is not clear.
Help Article Resources
Check out the Formula Handbook template!