Cell linking

Discussion List

  • Iterative Functionality (circular reference) in smartsheet.
    In Using Smartsheet
    I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it seems like a good feature to have built i…
    Answered - Pending Review
    56 2
    Answered - Pending Review 56 views 2 comments Most recent by Genevieve P. Using Smartsheet
  • Is it possible to query the URL's of sheets to table?
    In Using Smartsheet
    Hi there, I am trying to update some references on a roll up sheet and would like to quickly get the URL's of some key project artifacts. I'm not sure if there's a SQL type function in Smartsheet that would let me quickly let me get this …
    Answered - Pending Review
    21 4
    Answered - Pending Review 21 views 4 comments Most recent by summetg Using Smartsheet
  • Pulling data from another sheet (vlookup?)
    In Formulas and Functions
    Hello, I have a question about pulling data from another sheet and I'm hoping there is an easy way to do this. So I have 2 sheets, one is my main sheet with all my data (collected via form), and another sheet is my roster. On my main shee…
    Accepted
    500 13
    Answered ✓ 500 views 13 comments Most recent by Paul Newcome Formulas and Functions
  • How to record monthly changes in sheet?
    In Formulas and Functions
    So I am trying to get a formula to return a count of the number of cells that match but only if another column that records a date is within the last 30 days. I tried with reports but the issue is they don't display right if I try to send …
    Accepted
    27 3
    Answered ✓ 27 views 3 comments Most recent by KC Jones Formulas and Functions
  • Can I turn off the "Used in formula on" information screen?
    In Formulas and Functions
    I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
    Accepted
    190 9
    Answered ✓ 190 views 9 comments Most recent by Joe C. Formulas and Functions
  • Workaround for Voting
    In Using Smartsheet
    Hello, From other community questions I see that there is no voting functionality in Smartsheet but I am looking for a workaround. The use case is to have a system for internal enhancement requests to our ERP. Internal employees would have…
    Accepted
    667 8
    Answered ✓ 667 views 8 comments Most recent by Kyle Thompson Using Smartsheet
  • Unlink sheets
    In Formulas and Functions
    Hi, I have a folder with several documents (reports, project plans, etc.) and they are all linked to various different sheets in different workspaces. I accidently saved the folder as new, but I selected "Original Sheets". Is t…
    Answered - Pending Review
    3 1
    Answered - Pending Review 3 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • How to reference entire column from another sheet
    In Formulas and Functions
    Hi, I'm new to smartsheet and i would like to know how can i reference an entire column from another sheet, no criteria needed. I just want to return the data from sheet 1 column 1 to sheet 2 column 1, is there a simple way to achieve thi…
    Answered - Pending Review
    29 1
    Answered - Pending Review 29 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • 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
    6081 19
    Answered ✓ 6.1K views 19 comments Most recent by ldubois Formulas and Functions
  • Index & Collect Using Date Range
    In Formulas and Functions
    Hello, I'm trying to return cell values from another sheet based on a date range in a date field but I can't seem to get the formula to work. In a new sheet, I want to return the value of a specific cell from a different sheet based on t…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Jeff Reisman Formulas and Functions