Sheets
Discussion List
-
Max out Cross sheet reference ?In Using SmartsheetI 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…
-
Grouping info on reportsIn Using SmartsheetHi 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…
-
Create Summary SheetIn Using SmartsheetHi, 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?
-
Can I erase a reference name and reuse the reference name for another range?In Using SmartsheetCan 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…
-
Averaging RGB ballsIn Formulas and FunctionsI'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 views 6 comments 0 points Most recent by Leibel S Formulas and Functions
-
IF formula from multiple cell informationIn Formulas and FunctionsI'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 views 4 comments 0 points Most recent by Dale Callaway Formulas and Functions
-
Drop DownsIn Using SmartsheetI'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?
-
How do I copy a HWO to different Smartsheets once a checkbox is checked?In Formulas and FunctionsHi 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, JennAnswered - Pending Review 17 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Disappearing RowsIn Using SmartsheetI 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…
-
How to change formula for more then one criteriaIn Formulas and FunctionsSo 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…