Cell linking

Discussion List

  • Quickbooks & Smartsheet
    In API & Developers
    So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.  It has many application & the proof of concept exists and we use it.  We use it for an approval process (for in…
    4578 30
    4.6K views 30 comments Most recent by JeremiahHorstick API & Developers
  • Form Data
    In Using Smartsheet
    Hello totally new user to Smartsheet and need help on creating a form. I have looked at the posts but haven't found the answer, please help. 1) I need to create a form that will be filled by users to sign-up for different games. On the fo…
    Accepted
    22 3
    Accepted Answer 22 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Dashboard Reporting Logical Filtering
    In Using Smartsheet
    Hello, I am currently devolping an Automated Dashboard Template that may function as a Site Visit Report. The project consists of developing thousands of Site Visits Reports, hence the need for an automated system and data entry. I develo…
    Answered - Pending Review
    23 2
    Answered - Pending Review 23 views 2 comments Most recent by CSuarezIntegra Using Smartsheet
  • VLOOKUP/JOIN/COLLECT - Need help combining groups of emails
    In Formulas and Functions
    Good afternoon, I am stumped & hoping someone can help. In short, I have a Reference Sheet with the contact info and a Communication Plan Sheet. In the Reference Sheet, I added an Address/Filter/Email List column. The Email List is gro…
    Accepted
    22 3
    Accepted Answer 22 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • COMPLEX INDEX/MATCH arguments issue: Project Updates Tasklist
    In Formulas and Functions
    @Paul Newcome @Paul Newcome I need your expertise My manager has tasked me with referencing data from a hierarchy of rows, for multiple columns, but wanting the Parent Row to be updated from the inputs of the data in the CHILDREN rows, wh…
    Accepted
    26 3
    Accepted Answer 26 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Is there a way to refer to another "row" within comments/conversations? Refer to unique rows via URL
    In Using Smartsheet
    As a Smartsheet user, I want to be able to refer to a row when typing a comment so I can better give context and easily give URL's to navigate quickly to the other row. ---------------------- Use Case: I leave a comment on Row 1. Row 1 is…
    Accepted
    176 6
    Accepted Answer 176 views 6 comments Most recent by Brett Wyrick Using Smartsheet
  • Mark an old submission
    In Formulas and Functions
    Hi, I have a sheet I created where a name and status are being inputted through a Smarthseet form. I am trying to figure out a formula to mark old submissions. Meaning if someone submits a name with the status of "Onboarding" an…
    Accepted
    11 1
    Accepted Answer 11 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Duration is incorrect and inconsistent within same sheet
    In Using Smartsheet
    What I'm trying to do: Link "start date" and "duration" from Sheet A to Sheet B What's happening: I can link the cells just fine. But the duration is being calculated differently/incorrectly. Eg I have one row with a …
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Tessa B Using Smartsheet
  • How can I copy data from just a few columns to another sheet?
    In Formulas and Functions
    I have a large sheet where I would like to copy the data from just 7 columns to another sheet once the data in one of the columns matches the criteria needed. For example: Copy the data from the following columns to NewSheet once the Group…
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Auto populate data in Forms
    In Using Smartsheet
    I am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values. As per the attachment if we enter any ID in the CUS ID field it should populate the PSS Firs…
    2685 13
    2.7K views 13 comments Most recent by Andrée Starå Using Smartsheet