Multiple formulas on one sheet


Hello, I currently have a formula in column 1 of my sub-sheet copying data from my main source sheet. I'm trying to create a similar formula in column 2 of the same sub-sheet referencing my main source sheet. When I do this, the formula in column 2 is changing the formula in column 1. What am I doing wrong?

The formula for column 1 brings the BU# from the Intake Sheet to the Sub-Sheet. Here's the formula in that cell =INDEX(COLLECT({Willow Bridge Property Intake Sheet Range 1}, {Willow Bridge Property Intake Sheet Range 2}, [Property Name]@row), 1)

Can someone help me with a formula for column 2 to bring over this data from the Intake Sheet? I need "Fully executed PMA has been received" and the unique identifier will be the Property Name.

Thank you!


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    When you are entering the second formula, are you copy/pasting it from the first and then attempting to adjust the ranges? If so, you will need to completely remove the range you want to change from the second formula and create a brand new cross sheet reference. If you just click on "Edit reference", it will update all instances of that reference to point to the new column selected.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!