-
Merging data from multiple sheets
Hello I have over 100 smartsheets with the exact same columns and questions. These sheets have been sent out to leadership teams across the country. I need to combine all this data into ONE summary sheet. Is there a way to do that? I do not want to link EACH cell to hundreds of sheets. let me know if there is some magical…
-
Sheet Summary field, max date, ignore blank cells
Hi, I have a sheet with active jobs, some are scheduled and some are not. I want the Sheet Summary field to show the furthest date listed, but some of the rows do not have a date in the selected date column, and I want to be able to select the entire column to pull from so I don't have to expand the selection every time…
-
Conditional Formatting in same column with multi criteria
I am trying to think my way through this and can't quite manage it yet. I have a log that has stages but the criteria is based upon the substrate chosen. If Hot dip is selected, the temperature spec is 120-160. If Cold Rolled Steel is selected, the temp spec is 120-175. I need the conditional formatting in the same cell,…
-
Help with formula using YEAR function
I have a need to count rows where: Issue Type = Story Labels include LND-Product Status = Done Year of Resolution Date = 2020 COUNTIFS({JIRA Tickets Issue Type}, "Story", {JIRA Tickets Labels}, "LND-Product", {JIRA Tickets Status}, "Done", YEAR({JIRA Tickets Resolution}),= 2020)) Says the cell is Unparseable but I cannot…
-
Automatically update current stage
Hi, I am trying to track progress through various stages of publication (the columns titled approval, data collection, analysis...accepted). I thought the health bubbles may be a good way to quickly visualize progress but it is confusing the card view as it can only organize per specified column at a time. What would be…
-
Long Decimals - 7 digit decimals
Good morning, I have specific coding for each line item that reads as 7 digits with a "." followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes…
-
Combine a column from two different sheets ="Complete"
I am attempting to take info from a column from two different sheets and combine the total. The formula I am working with to perform this for a single column is: =COUNTIF({Project Plan - Project A Range 1},="Complete") I tried using the following: =COUNTIFS({Project Plan - Project A Range 1}, ="Complete", {Project Plan -…
-
"SUMIFS" with "AND" and "@cell" combination returning wrong value
Where [Begin]@row = DATE(2020, 7, 1) and [End]@row = DATE(2020, 7, 31) The following formula returns returns incorrect value: =SUMIFS({Maint-MLR-LaborHours}, {Maint-MLR-DateCompleted}, AND(@cell >= [Begin]@row, @cell <= [End]@row)) But, the following formula returns correct value: =SUMIFS({Maint-MLR-LaborHours},…
-
How do I reference the contents of a specific cell in a different sheet in the sheet summary?
Hello, Basically, I am trying to write a formula in the Sheet Summary of a sheet that shows the contents of another cell on a different sheet. I am able to write a within sheet cell reference for example, =[Latest Update]77. However, I want to change that formula to reference a specific cell from a different sheet. I've…
-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…
