Cell linking


Discussion List

  • 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'…
    15 3
    Question 15 views 3 comments Most recent by CAI-RAS Formulas and Functions
  • Auto populate data in Forms
    In Using Smartsheet
    I am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values. As per the attachment if we enter any ID in the CUS ID field it should populate the PSS Firs…
    2164 9
    2.2K views 9 comments Most recent by Andrée Starå Using Smartsheet
  • 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…
    94 5
    94 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
    1 1
    Answered - Pending Review 1 view 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
    508 10
    Answered - Pending Review 508 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.…
    2092 13
    2.1K 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…
    1 1
    Accepted Answer 1 view 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
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå Formulas and Functions