Sheets

Discussion List

  • 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
    36 10
    Accepted Answer 36 views 10 comments Most recent by Lynna Using Smartsheet
  • Grouping info on reports
    In Using Smartsheet
    Hi all, I have 3 spreadsheets for which i want to report information from. All of them have common information/references (i.e. POW1234) but the name of the columns where that information is will be different from spreadsheet to spreadshe…
    Answered - Pending Review
    19 1
    Answered - Pending Review 19 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Create Summary Sheet
    In Using Smartsheet
    Hi, I have been unable to create a summary sheet which I think will work better with charts on the dashboard. I created this report but want to do the same thing in a metric sheet. I am lost as to how to accomplish this. Any advice?
    Answered - Pending Review
    23 5
    Answered - Pending Review 23 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Can I erase a reference name and reuse the reference name for another range?
    In Using Smartsheet
    Can I erase a reference name and reuse the reference name for another range?  It looks like once I use a reference name and mark the range, I can't erase the name and reuse the reference name for another range? it will indicate the name al…
    Accepted
    20 3
    Accepted Answer 20 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • Averaging RGB balls
    In Formulas and Functions
    I'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue …
    Answered - Pending Review
    31 6
    Answered - Pending Review 31 views 6 comments Most recent by Leibel S Formulas and Functions
  • IF formula from multiple cell information
    In Formulas and Functions
    I've been tasked to show the approval status of a row. Due to how I created the automation, depending on the level of an award (same sheet as referred to recently) the Manager signer may show status in 1 of 3 different columns. I want to …
    Answered - Pending Review
    24 4
    Answered - Pending Review 24 views 4 comments Most recent by Dale Callaway Formulas and Functions
  • Drop Downs
    In Using Smartsheet
    I'm using multiple dropdown columns on my smartsheet, most work, but a couple don't. When I try to click on the dropdown, nothing happens. Not sure why?
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Melita Clark Using Smartsheet
  • How do I copy a HWO to different Smartsheets once a checkbox is checked?
    In Formulas and Functions
    Hi all, I am looking to build out functionality that copies a HWO to multiple Smartsheets once a checkbox is checked. Is there a way to do this without cell linking or copying the full row? Thanks, Jenn
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Disappearing Rows
    In Using Smartsheet
    I have what I hope is a basic problem. One of my users has a fairly uncomplicated grid the she uses to keep track of submissions. When she adds new rows, they disappear upon saving the sheet. When I look at the sheet, I can see the new row…
    Answered - Pending Review
    19 3
    Answered - Pending Review 19 views 3 comments Most recent by Mark Cronk Using Smartsheet
  • How to change formula for more then one criteria
    In Formulas and Functions
    So this formula works for me. I am trying to add another criteria though and cant figure it out. =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Stained") And it works but i want it to add the "s…
    Accepted
    17 3
    Accepted Answer 17 views 3 comments Most recent by Mike Wilday Formulas and Functions