I am trying to replicate a formula, but it is changing all the formulas on the page

Options

I am trying to create the formula in the "Activities" row, to the "Issues/Pain points" row with a different reference column. I also need to change the reference sheet, but I want to get this formula right in the first instance.

Can anyone help?

Best Answer

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Tamar

    I think this is happening becuase you are editing a range that exists in the original location. Instead of editing the range in the new location, be sure to delete the entire range and then click in the place where it was in the formula. Then choose another range.

    I hope that helps.

    Matt

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Answers

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Tamar

    I think this is happening becuase you are editing a range that exists in the original location. Instead of editing the range in the new location, be sure to delete the entire range and then click in the place where it was in the formula. Then choose another range.

    I hope that helps.

    Matt

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!