Sheets

Discussion List

  • Is it possible to fill a column without Drag-Fill
    In Using Smartsheet
    Hey, I am new to smartsheet and hope you can help me with this: I want to write something in the top data field and then the text, number or date should be automatically copied to the rest of the column. I found this site: Create a Ser…
    Accepted
    24 5
    Answered ✓ 24 views 5 comments Most recent by TippKick23 Using Smartsheet
  • How to copy the latest comment in a row to a cell?
    In Formulas and Functions
    Hi all, I'm building a new sheet where we want to use the comments function, but I'd like to have a "read only" of the latest comment left by a user and with the time a date in a cell. This would help summarize the latest detail …
    Answered - Pending Review
    44 6
    Answered - Pending Review 44 views 6 comments Most recent by summetg Formulas and Functions
  • Anyway we can automate SmartSheet to remove / delete rows.
    In Using Smartsheet
    I have a dump sheet that needs to be clear every day. Move row does not work, its adds another step into a simple task.
    Answered - Pending Review
    15 4
    Answered - Pending Review 15 views 4 comments Most recent by heyjay Using Smartsheet
  • Count and Distinct Formula returns 1
    In Formulas and Functions
    Hi, I'd like to retrieve the total values excluding duplicates, this is the formula used: =COUNT(DISTINCT([Part Number]:[Part Number])) ; using the count formula only returns the total value of 3535, which is correct considering duplicated…
    Accepted
    23 4
    Answered ✓ 23 views 4 comments Most recent by lschek1 Formulas and Functions
  • What happens to my automation if I run out of rows?
    In Using Smartsheet
    Hey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet to the archive sheet- we keep that for…
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Get Average of "checkboxes checked" for an entire column reference from another sheet
    In Formulas and Functions
    Hi Everyone - I'm trying to get an average of "checkboxes checked" for an entire column range. I came up below but it's not working. =COUNTIF({1 Main Speaker System Range 2}, 1 / COUNT({1 Main Speaker System Range 2})) I was su…
    Accepted
    27 9
    Answered ✓ 27 views 9 comments Most recent by Danny Lam Formulas and Functions
  • Dashboard breaks after removing an Admin (original owner/builder of Dashboard but not current)
    In Using Smartsheet
    We have a Dashboard (several Dashboards that this same behavior happens on) that was built by one person. The Ownership for the Dashboard and ALL associated items (Metrics Sheets, Reports, Source Sheets, etc.) were transferred to another p…
    Answered - Pending Review
    23 4
    Answered - Pending Review 23 views 4 comments Most recent by Kayla Using Smartsheet
  • Max out Cross sheet reference ?
    In Using Smartsheet
    I have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references."  How to resolve this issue? I already deleted many rows to reduce the c…
    Accepted
    399 15
    Answered ✓ 399 views 15 comments Most recent by Paul Newcome Using Smartsheet
  • Vlookup a cell with a formula
    In Formulas and Functions
    Hello everyone, I am trying to use a normal Vlookup function in smartsheet. The search_value (number) and also the value that is supposed to be looked up in the look_up table (same number) are also pulled with other formulas. If I hardcode…
    Answered - Pending Review
    17 4
    Answered - Pending Review 17 views 4 comments Most recent by Dennis92 Formulas and Functions
  • TotalFloat inconsistency between parent and child tasks
    In Formulas and Functions
    I am looking to utilize TotalFloat in a project plan and am finding inconsistent results with parent and children tasks. The sheet is set to Mon-Fri working days with no holidays set. The formula in use is =TOTALFLOAT([Task Name]@row) + &q…
    Answered - Pending Review
    45 2
    Answered - Pending Review 45 views 2 comments Most recent by Paul M Kahl Formulas and Functions