Automation to extract specific lines

Hello everyone,

Is there a way to extract lines using Automation? What I am after, is to extract the 3 lines marked, on trigger. Full lines is preferred. The 2 bottom lines are always "Fan Model" and Silencer type".

Thank you everyone in advance for your kind suggestions.

Wilson

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Extract and do what with them exactly?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • wting
    wting ✭✭

    Hi Paul,


    Thanks for the reply. I am looking for a way to automate an email showing me the Job number and name, Fan model and Silencer model used for each job we book up.

    In this example, I am looking for M2373 Malmsbury, Fan Model - 6-35-5.6A-KT/15kw-2, Silencer type - Industrial 15kw, 6-35-5.6A-KT/15kw-2. All this can be in the subject or the body of the email.

    Can this be done with Smartsheet? I am going through old records in excel format now to extract this data. I just need the new booking to "alert" me from now on.


    Thank you.


    Kind regards,


    Wilson

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @wting

    I hope you're well and safe!

    Depending on how you send the information, you could add a so-called helper column and a specific cell with the information you'd like to include in the message.

    Try something like this and update the column names to yours.

    =Primary2 + CHAR(10) + Details10 + CHAR(10) + Details11

    Did that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need to have all of this information going out across the same row. You can use helper columns for each piece or a single column to join it all together in a string.


    Then in the automation you can either just have the alert send you the cell(s) or use a {{Placeholder}} within the subject or body of a custom message.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • wting
    wting ✭✭

    Thank you Andree. Hope you are well and safe too. I will give it a go. I only have basic understanding of Smartsheet, but keen to learn.

  • wting
    wting ✭✭

    Hi Paul,

    My understanding of what you are suggesting is to convert the cells in each line into columns. That means to link the cells to another sheet first, then generate the automation from the new sheet. Am I correct?


    Thank you for your help.


    Kind regards,


    Wting

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    No. I meant within the source sheet. You can create helper column(s) (that can be hidden after setting up to keep the sheet looking clean).


    You can use formulas and/or basic cell references to replicate this data across a single row whether that be in separate columns or combined into a single column on whichever row you want to trigger the automation.


    =[Column4]@row + CHAR(10) + [Column4]2 + CHAR(10) + [Column4]3

    or

    =[Column4]1

    =[Column4]2

    =[Column4]3

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com