How to drag formula and prevent cells linking together reference sheets?

When I enter a formula (e.g countif) that references another sheet, and then drag this formula to the next rows and try to change the sheet referenced, it changes all the cells as if the formula is linked between all the cells. How do I replicate a formula I want to be in multiple rows but then edit each row to reference a different sheet within that same formula (without it changing/linking all of them together)?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!