sean59916 ✭✭✭

Overview

Overview

Roles	Member
Badges	11

About Me

About Me

Area of Expertise	Apps/Integrations
About Me	Hello!<br /><br />I'm based near Sydney, Australia working fulltime on Smartsheet based solutions and apps particularly those that require automation or integrations to other services. <br /><br />Feel free to contact me - sean@bluskytechnologies.co with any Smartsheet related challenges that you are facing.
Linkedin	https://www.linkedin.com/in/mrseanwilliams/

Analytics

108

Posts

25

Visits

95

Points

Aug 30, 2018

Join Date

Feb 20, 2021

Last Active

Reactions

• Insightful 4

  4
• Vote Up 6

  6

• Activity
• Discussions7
• Comments101

• Re: Datamesh

  sean59916

  12/17/18
  Hi Michael Based on my experience with Datamesh, I would recommend (and i think Smartsheet does too) using cross-sheet formulas. See: https://community.smartsheet.com/discussion/alternative-vlookup-s…
  1 ·

• Re: Examples of more than 1 Data Mesh Target Sheet

  sean59916

  05/16/20
  Hi - I use the DataMesh tool a fair amount and Yes, you can have up to 5 target sheets as you mentioned - the columns in the target sheets need to be the same name and same column type. Eg. Source Co…
  1 ·

• Re: Split Text to Columns Using Formula?

  sean59916

  05/28/19
  Hi, This is how I achieved the results you are requesting: * Add 2 columns, with the following formulas per column * =LEFT([Column6]2, FIND(":", [Column6]2) - 1) * =RIGHT([Column6]2, LEN([C…
  4 ·