Cross sheet formulas referencing different columns

mwong

Hello,

When creating a formula with cross-reference sheets, do all of the columns need to use the same source? For example, I would like the second part of the formula pull from 2 different columns, but when it's pulling from the same source. When I change the formula, it affects the others too; I get this notice.

mwong

Never mind, I figured it out. Since I was selecting the first formula I used and did a 'copy/paste', even though I edited the cross sheet formula, it was linking them to all be the same.

When I wrote out the formula individually for each column, it worked.

Andrée Starå

Hi @mwong

I hope you're well and safe!

Excellent!

Glad you got it working!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!