Cell linking

Discussion List

  • Connect sheets without manual cell linking
    In Formulas and Functions
    I have a project roadmap (activity name, start date, end date, etc) and then a separate sheet where we want to pull from the existing project roadmap. With roadmaps, information is always changing or being added and I want the separate she…
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Jennifer Greenough Formulas and Functions
  • Help using a multiple cell criteria from a source sheet to auto populate a formula sheet
    In Formulas and Functions
    I'm stuck. Really stuck. I've attempted more than 30 formulas. I hope someone can help me. I am using a master HR data file with 1500+ rows (reference/source sheet) to auto-populate a training enrollment roster (formula sheet), only I don'…
    Accepted
    21 5
    Accepted Answer 21 views 5 comments Most recent by CAI-RAS Formulas and Functions
  • Cell Linking from a Form
    In Using Smartsheet
    Hello I am trying to do cell linking from when the information is entered in from a form rather than directly onto the sheet itself.  When I do this it adds the information onto the sheet however it moves the cells I am trying to link down…
    127 5
    127 views 5 comments Most recent by Sharon Isaac Using Smartsheet
  • Report not updating after source sheet is edited and saved
    In Using Smartsheet
    Hi, I am trying to update a report but whenever the source sheet is updated and saved, those updates do not filter into the report. I have tried waiting to see if it just takes some time to update, refreshing both sheet and report, closing…
    Answered - Pending Review
    43 1
    Answered - Pending Review 43 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Linking checkboxes across 2 sheets
    In Formulas and Functions
    I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered dat…
    Answered - Pending Review
    651 10
    Answered - Pending Review 651 views 10 comments Most recent by Paul Newcome Formulas and Functions
  • Using a profile matrix to drive automation on specific dates
    In Formulas and Functions
    I have a profile matrix that has a set of dates across the top (columns), row 1 and then a list of product types (Student, Teacher, Classroom) for each record, starting at row 2. On a separate sheet I have a list of products that associate…
    Answered - Pending Review
    31 3
    Answered - Pending Review 31 views 3 comments Most recent by Paul Reeves Formulas and Functions
  • Can Formulas Reference Reports?
    In Formulas and Functions
    I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…
    2590 13
    2.6K views 13 comments Most recent by Daniel Heidt Formulas and Functions
  • Multiply cell by 2 if checkbox is checked
    In Formulas and Functions
    Hey Smartsheet users! I've read through a lot of check and IF formulas and haven't been able to find my answer so here is the situation. This is for a mileage reimbursement form. I have a column titled "Mileage" and another colum…
    Accepted
    5 1
    Accepted Answer 5 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Cells Not Linking
    In Using Smartsheet
    When I copy cells from one sheet and paste them onto another, I right-click and want to use the Paste Special > Links to Copied Cells option, but it's often grayed out. Not sure what I'm doing wrong. It worked for the first 20 cells and…
    Answered - Pending Review
    2 4
    Answered - Pending Review 2 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • if checkbox is checked, capture a value from same row and populate separate sheet
    In Formulas and Functions
    I would like to capture values from specific rows on a source sheet (Estimate Summary) when a check box is checked and send those values to a destination sheet (Allowance Log). When the checkbox is not checked on the Estimate Summary shee…
    Answered - Pending Review
    112 1
    Answered - Pending Review 112 views 1 comment Most recent by Andrée Starå Formulas and Functions