Automatic "Cell linking"

ClayBuell ✭✭✭
edited 12/09/19 in Formulas and Functions

*What would be the best way to create a permanent link between cells.  

What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automatically.  

We basically develop real estate and the project might start out known as the "Nome project" and gets assigned a Project Number.  

I want a way to "link" up all four of these bits of project info so they're always stay together.  

Is this possible without a third-party app?


** This is a fictitious project example **

screen capture for community.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!