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…
    5902 33
    5.9K views 33 comments Most recent by JeremiahHorstick API & Developers
  • Countifs with Row Reference
    In Formulas and Functions
    Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the…
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Katy H Formulas and Functions
  • Automating a daisy-chain of tasks with Updates and Status
    In Using Smartsheet
    Currently stuck trying to automate the completion of one task to trigger the next. The situation: All data is on one row per project. Each task is listed there and on its own sheet. And everything needs to work through Update Requests. No …
    19 1
    Answered ✓ 19 views 1 comment Most recent by Tristan Using Smartsheet
  • Possible bug: Smartsheet adds a trailing space to random cells
    In Using Smartsheet
    I've encountered some strange behavior where Smartsheet automatically adds a trailing space to a cell. Below are two columns. The right column adds a "|" to the value in the left column. You can see that in the penultimate row a…
    42 2
    Answered ✓ 42 views 2 comments Most recent by JKrombeenASK Using Smartsheet
  • Is it possible to automate link creation between 2 smarthsheets?
    In Using Smartsheet
    Regarding the question above, consider a scenario where 1 project requires 2 linked smartsheets. Now consider a scenario where 50+ projects each require 2 linked smartsheets and a new project is added to the que 2 or 3 times a week. Is …
    86 7
    Answered ✓ 86 views 7 comments Most recent by Genevieve P. Using Smartsheet
  • Maps & Hyperlinks
    In API & Developers
    I know that the smartsheet charts app is still in production, but is it possible to have sheet containing North American states and hyperlinks, then  using the 'map' chart, click on a particular state and then it will take you to that hype…
    966 6
    966 views 6 comments Most recent by talexander90516 API & Developers
  • Help With Index Match (#Invalid value)
    In Formulas and Functions
    I am trying to return a Contact value Cell from a lookup table, in the Column "Assigned Contact Email" according to "Week * + Day*" and "Shift Assigned To" in that Row This is what I want it to look like. ^ Th…
    Answered - Pending Review
    18 2
    Answered - Pending Review 18 views 2 comments Most recent by JPFORDTE Formulas and Functions
  • Updating references on a template and deploying changes via SCC
    In Formulas and Functions
    Hi all, I am trying to update an existing metadata sheet in our solution build via SCC. I was able to make the changes on the sheet itself and have applied it at the template and test with an existing team dashboard. I realized after I wi…
    Answered - Pending Review
    22 4
    Answered - Pending Review 22 views 4 comments Most recent by summetg Formulas and Functions
  • Hierarchy issues
    In Formulas and Functions
    Hi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin but recently left for another job. I h…
    Answered - Pending Review
    20 3
    Answered - Pending Review 20 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • COUNTIFs formula with Date Range
    In Formulas and Functions
    Hello, I am trying to create a monthly trend report. The report function is not specific enough for what I need, so in order to do this, I have created a metrics sheet that references 21 different originating sheets. To fill my metrics sh…
    43 11
    Answered ✓ 43 views 11 comments Most recent by Paula Meunier Formulas and Functions