Cell Link Reference

Wahaj Y Khan

Hi I have survey data on one sheet which I am trying to bring over to my "Weekly Implementation" report through cell reference link but its not letting me. After creating a link all I see is "processing" but number don't come over to the second sheet ? please help

Andrée Starå

Hi @Wahaj Y Khan

I hope you're well and safe!

It looks like you're adding a Cross-Sheet Reference and not a Cell-link, and that's why you don't see anything, and it's processing because there aren't any formulas using the Reference.

Here's more information about cell linking.

https://help.smartsheet.com/articles/861579-cell-linking

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Wahaj Y Khan

I hope you're well and safe!

It looks like you're adding a Cross-Sheet Reference and not a Cell-link, and that's why you don't see anything, and it's processing because there aren't any formulas using the Reference.

Here's more information about cell linking.

https://help.smartsheet.com/articles/861579-cell-linking

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Wahaj Y Khan

@Andrée Starå It worked when i clicked "Link from cell in another sheet" and i applied conditional formatting also, see below numbers transported over.

Andrée Starå

@Wahaj Y Khan

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!