Re-using formulas with reference on multiple sheets


Is there any way for us to re-use the formulas created that reference a specific sheet? Or do we need to manually create the reference for each sheet where we are trying to use the formula on?

I'm trying to create general formulas using the MATCH function which is referencing the lookup table from a specific "Master" sheet. I want to apply said formulas on various sheets without needing to basically re-do them every time I want to use them on a different/new sheet.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!