Linking cells into other sheets - Latest update only

Emad Haddad · 01/18/24

Is there a way to link a cell from one sheet to another, but only link over the latest change from changed cell?

Lee Joramo · 01/19/24

Still not sure about this, but it does sound like you have a cell that contains multiple lines of text, and not multiple rows in the same column. Lets say the following is in Column "Notes" and Row 1

01/25/24: New Hard Drive installed

01/12/24: After investigation, hard drive noted as issue. Replacement purchased.

01/04/24: Customer states issue with computer.

If the lines are split by a "New Line" Character, we need a way to find the "New Line" Character. We can do this by using the CHAR function. A New Line character should be CHAR(10)

We can now get the first line by using this formula:

=LEFT([Notes]1, FIND(CHAR(10), [Notes]1))

which returns 01/25/24: New Hard Drive installed

Andrée Starå · 01/19/24

Hi @Emad Haddad

I hope you're well and safe!

Not sure I follow. Can you elaborate?

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Emad Haddad · 01/19/24

Could you link sheet 2, cell 2 to only see the latest update from sheet 1, cell 1?

Lee Joramo · 01/19/24

This is still not clear to me. I am gathering that a VLOOKUP function will not work?

Are you wanting Sheet 2, Cell2 to keep the value "01/25/24: New hard drive installed" even if Sheet 1, Cell 1 is again updated?

... or ...

Sheet 1, Cell 1 contain multiple lines, and you only want the first line?

... or ...

something else?

Emad Haddad · 01/19/24

Lee,

If I follow the same format above in sheet 1, cell 1 as standard, then I suppose I can just pull the first line only as that should represent the most recent change.

Lee Joramo · 01/19/24

Still not sure about this, but it does sound like you have a cell that contains multiple lines of text, and not multiple rows in the same column. Lets say the following is in Column "Notes" and Row 1

01/25/24: New Hard Drive installed

01/12/24: After investigation, hard drive noted as issue. Replacement purchased.

01/04/24: Customer states issue with computer.

If the lines are split by a "New Line" Character, we need a way to find the "New Line" Character. We can do this by using the CHAR function. A New Line character should be CHAR(10)

We can now get the first line by using this formula:

=LEFT([Notes]1, FIND(CHAR(10), [Notes]1))

which returns 01/25/24: New Hard Drive installed

Emad Haddad · 01/19/24

https://community.smartsheet.com/discussion/comment/414581#Comment_414581

Lee,

This is what I am looking for! Now is there a way I can reference the [Notes]1 Cell from a separate sheet?

Lee Joramo · 01/19/24

Emad,

For that you will use the vlookup() function

https://help.smartsheet.com/function/vlookup

and Cross Sheet References

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Linking cells into other sheets - Latest update only

Best Answer

Answers

Categories