Cell linking

Discussion List

  • third party application recommendation for robust sharing automation between sheets
    In Using Smartsheet
    Hi there, I'm looking to see if there an application that can handle a little more robust automation of sharing between sheets. I'm looking to create one form that can populate and update several different sheets. do I need a third party…
    7 0
    Question 7 views 0 comments Started by Deanna L Using Smartsheet
  • Drop down list from another sheet
    In Formulas and Functions
    I currently have two sheets. Sheet1: Company List, Sheet2: Contacts. I am trying to create a dropdown column listing the companies from Sheet1 to populate the drop down for a column in Sheet2. This would essentially work as a lookup to …
    3307 14
    Accepted Answer 3.3K views 14 comments Most recent by Andrée Starå Formulas and Functions
  • Indirect style look up from another sheet
    In Using Smartsheet
    Hello, I am trying to access data from another sheet using a reference to another column within the row using a sum formula usually in excel I would create a =indirect() reference, how could I replicate something like that within smartshee…
    Answered - Pending Review
    32 1
    Answered - Pending Review 32 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Is there a work around for trying to use CONTAINS() or HAS() within collect()?
    In Formulas and Functions
    I am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a multi select column (I have also tri…
    19 3
    Accepted Answer 19 views 3 comments Most recent by Greg F Formulas and Functions
  • Track inventory movement in multiple warehouse locations
    In Formulas and Functions
    Hi, We would like to track inventory movement between multiple warehouse locations, there is no need to track stock value/sales, just need to track inventory movement between locations and the inventory balance Warehouse: Warehouse A, War…
    Answered - Pending Review
    37 2
    Answered - Pending Review 37 views 2 comments Most recent by Ashley356 Formulas and Functions
  • Timestamping
    In Formulas and Functions
    Hello. Is there currently anyway to do timestamping in Smartsheets?  For instance, timestamping a cell when a tick box cell is ticked? Thanks             Andrew  
    118 10
    118 views 10 comments Most recent by Andrée Starå Formulas and Functions
  • TimeStamp Formula Value
    In Using Smartsheet
    Hi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match …
    3992 8
    Accepted Answer 4K views 8 comments Most recent by Andrée Starå Using Smartsheet
  • Is there a way to easily/quickly hyperlink 100's of sheets.
    In Formulas and Functions
    I am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink and go directly to that person's individu…
    Answered - Pending Review
    21 3
    Answered - Pending Review 21 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Sorting & Filtering Linked Cells From Source Sheet
    In Using Smartsheet
    I am unable to figure out how to sort and filter linked cells from the source sheet. I have a sheet with cell links which needs to be sorted or filtered when the source sheet is sorted or filtered. I am unable to use a report or dashboard…
    309 7
    309 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Help with Trend Data
    In Formulas and Functions
    I need some help with collecting data for trending.  Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet.  On this roll-up sheet I have data that is calculated from the project Status. …
    1413 15
    1.4K views 15 comments Most recent by Nora G Formulas and Functions