Cell linking

Discussion List

  • Adding a link to specific row on a sheet
    In Using Smartsheet
    I have a sheet that has hundreds of rows and want to add an anchor type link to the top of that sheet so that I can easily go to a specific row within that sheet.  Can someone help me with this?  
    801 4
    801 views 4 comments Most recent by Victor Sauceda Using Smartsheet
  • Link to another sheet and conditionally output
    In Using Smartsheet
    Hello, I have one sheet that I am trying to link to and output data conditionally. There is a "LineItem to WPID" sheet where I am trying to bring in the WPIDs from my "WPID Matrix" where the LineItem header matches with…
    Accepted
    23 4
    Accepted Answer 23 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • I need to determine if a date column is blank then it returns a message
    In Formulas and Functions
    Hello, I want help with a formula to return a message that says met goal if the date is blank or did not meet if the date is populated. I tried this formula but it is not working it returns #Unparseable =IF(ISDATE([Request Intake Range 9]1…
    Answered - Pending Review
    17 2
    Answered - Pending Review 17 views 2 comments Most recent by HFletcher Formulas and Functions
  • Locking Values in Row
    In Formulas and Functions
    I have a column on Sheet 1 that has a formula that references a value on Sheet 2. If the value on Sheet 2 changes,  obviously the cell in Sheet 1 updates automatically.  I have another cell in Sheet 1 that is a dropdown. One value in the …
    503 10
    503 views 10 comments Most recent by Tim Starkey Formulas and Functions
  • COUNTIFS Issues
    In Formulas and Functions
    I am having problems getting COUNTIFS to work. I have two different formulas I am trying to set-up in different columns. I would also like cells that return as zero to change to blank. Does anyone know how I can fix my formulas and also se…
    Answered - Pending Review
    53 1
    Answered - Pending Review 53 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Need to Count Distinct Based on Multiple Criteria
    In Formulas and Functions
    Hi there! I have a database (Sheet 1) where I log all my company's gifting to social media influencers and the subsequent exposure on Social Media in one sheet. I organize them by the Name of Influencer, the month we gifted, the month the…
    Accepted
    24 9
    Accepted Answer 24 views 9 comments Most recent by Bassam Khalil Formulas and Functions
  • 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
    23 1
    Answered - Pending Review 23 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
    22 5
    Accepted Answer 22 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…
    151 5
    151 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
    62 1
    Answered - Pending Review 62 views 1 comment Most recent by Andrée Starå Using Smartsheet