Cell linking

Discussion List

  • 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 …
    Accepted
    3234 14
    Accepted Answer 3.2K 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
    31 1
    Answered - Pending Review 31 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…
    Accepted
    16 3
    Accepted Answer 16 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
    36 2
    Answered - Pending Review 36 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  
    114 10
    114 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 …
    Accepted
    3968 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
    19 3
    Answered - Pending Review 19 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…
    300 7
    300 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. …
    1405 15
    1.4K views 15 comments Most recent by Nora G Formulas and Functions
  • Cross Project Dependencies
    In Using Smartsheet
    Hi SmartSheet Community! I have built a portfolio of projects and I want to create an additional project within the portfolio to capture action items that need to be completed before some of the tasks in the related projects could complete…
    Accepted
    21 2
    Accepted Answer 21 views 2 comments Most recent by PattiL Using Smartsheet