Cell linking

Discussion List

  • Is there a way to update referenced sheets using vlookup and/or index and match?
    In Formulas and Functions
    Hi there, We have an issue where we provision a project from our intake sheet, but after it hits the project roll up sheet, we can't update the status. Here's a summary of how our workflow: Intake listing sheet - has our projects intake,…
    Answered - Pending Review
    48 1
    Answered - Pending Review 48 views 1 comment Most recent by Heath Hilton Formulas and Functions
  • How can I link my sheets in Workspaces?
    In Using Smartsheet
    Hello, I'm wondering if there's a way to link my sheets in workspaces, we want something that will transfer onto the other sheets or have something in red trigger another sheet into auto generating it there to know what task needs to be co…
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • help with formula's
    In Using Smartsheet
    hello new to smartsheets. i am looking to make a V lookup that will crosslookup on 2 sheet to tell me if it is on that sheet or not. this is what i come up with so far. =IFERROR(IF(ISBLANK($[Cable Name]@row), VLOOKUP($[Cable Name]@row, {K2…
    Accepted
    24 1
    Answered ✓ 24 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Need Help with Formula for Metrics
    In Formulas and Functions
    Hi, I am stumped at a formula for this sheet. Please see picture below. I am trying to calculate an action taken goal where we take the levels standard, urgent, and immediate and the action taken days. The parameter is for standard 3 days,…
    Accepted
    21 2
    Answered ✓ 21 views 2 comments Most recent by HFletcher Formulas and Functions
  • Is autofill possible in this scenario? and how
    In Formulas and Functions
    I am working on a calendar form and I would like if I entered a specific name of an event, that the next column would autofill a number. For example, if in the "event Name" column I type "Marathon", I would like the nex…
    Answered - Pending Review
    39 7
    Answered - Pending Review 39 views 7 comments Most recent by Andrée Starå Formulas and Functions
  • Pulling out data from a master sheet
    In Using Smartsheet
    Hi all, I'm in need of a solution to track activities. There is a master sheet that I have view access to where items get added by different parties. I want to pull out data based on a filter to create a tracking tool to make sure that my…
    Answered - Pending Review
    86 7
    Answered - Pending Review 86 views 7 comments Most recent by GrahamWelsby Using Smartsheet
  • Formula for Referencing Cell Above Current Cell?
    In Formulas and Functions
    I have created this Smartsheet, where my team can record orders raised each month. This would then link to a dashboard (which would have to update automatically each month) to show monthly statistics regarding the orders from that month. …
    Answered - Pending Review
    106 1
    Answered - Pending Review 106 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Graphs from Excel into Smartsheet
    In API & Developers
    Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data. 
    659 6
    659 views 6 comments Most recent by J25 API & Developers
  • Tracking a sum from separate column of specific values
    In Formulas and Functions
    Hello, First, I want to thank all of you for your help on this community. I'm learning a lot and this place has helped me out immensely. I've looked around and have found some similar questions, but I can't seem to get this to work, so I w…
    Accepted
    16 3
    Answered ✓ 16 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Am unable to retrieve Dates from one smartsheet to other
    In Formulas and Functions
    While am trying to use vlookup function the limitation threshold is an error prompt. I tried to use Collect and Index Collect function however they are giving me error prompts as # Date Expected and Incorrect Value
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Andrée Starå Formulas and Functions