Cell reference - when original cell content is deleted, the referencing cell still shows value

Sylvia Kay
Sylvia Kay ✭✭✭✭
edited 10/19/22 in Formulas and Functions

I have two Sheets. In Sheet A I have my full content. I am displaying some cell content from Sheet A in my Sheet B. I created the referencing as a Column Formula, so that if I add another row to my Sheet A, it automatically displays in Sheet B. That works just find.

What does not work is if I later on decide to delete a row in Sheet A. After I did that, the now deleted value is still displaying in Sheet B. My expectation would be that if it is deleted in the Source Sheet A, it would also not display anymore in Sheet B.

I am using the "link in from" another Sheet function.

Can you please advise?

SYLVIA KAY | DIRECTOR PROJECT MANAGEMENT

PLATFORM ENGINEERING & TECHNOLOGY TEAM

AMERICAN EXPRESS GLOBAL BUSINESS TRAVEL

M: 404-664- 1025 | SYLVIA.KAY@AMEXGBT.COM

AMEXGLOBALBUSINESSTRAVEL.COM

follow us on twitter: @AmexGBT

follow us on instagram: @AmexGBT

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!