-
Best Practices for Browser Zoom - HOW TO TURN THE ALERT OFF??
I know there may be some row alignment or auto-scrolling issues if my browser zoom is set <90% but these things wouldn't impact what I'm doing 90% of the time; however, the message at the top of my screen is relentless and disruptive. Aside from fixing zoom %, does anyone know how to prevent this alert from alerting?…
-
Using Logic to Autofill Other Fields in a Form
I have a form where a user would select options from a drop down. Ideally, like to setup logic so that when they select option D, there is another form field (let's just call it Field 2) that is then hidden and has its value set. There are other times when if they were to chose Option C, they would need to decide what…
-
Dashboard card view
Hi, On I have sheet on my dashboard. I would like it to be viewd in CARD VIEW mode by default. Ufortunately every time I refresh the dashboard it has GRID VIEW. Is it possible to work it out?
-
Grouping Rows
Hello, I have created a smartsheet update tracker, in the format shown in the screenshot below. The separate teams provide their updates in the nested row of the spreadsheet. There are also many formulas on the sheet. I would like to sort these rows from time to time so they can display in progress projects at the top,…
-
Report Grouping Summary Rows in Dashboard & Attachements
Is there any update on when reports might keep the grouping/summary rows when sent as an attachment or displaying on a dashboard? I remember hearing this was 'in the works' back in February.
-
Is there a way to get the name of a sheet?
I could not seem to find this anywhere, maybe I just missed it. Is there a way to get the name of the current sheet in a cell? In other words I would like use the name of the sheet so I can parse it for a vlookup.
-
IF Formula Help
Hi guys, I would like to implement the following automation process of "% Complete" -> "Status". The approach would be: IF: % Complete: 0% -> "Not Started" IF: % Complete: 0% ≤x≤ 100% -> "In Progress" IF: % Complete: 100% -> "Completed" My current IF formula does not display and consider the last 2 conditions, I honestly…
-
Reference Formulas in Templates
Hello, I have created two templates from sheets that reference each other in a SUM+DATE formula. I would like the new sheets created by the template to reference each other, but at this moment they reference the old sheet from which the template came and need to be changed manually. Any way to achieve this? Thanks in…
-
Average/Roll Up Harvey Ball % Complete Symbol in Parent Row
Hello, I have a feeling this is going to be so simple, but I cannot seem to figure out how to average the values of the Harvey Ball % Complete symbol in a parent row. Per my screenshot, I want the Harvey Ball with the red arrow to average the values of the Harvey Balls beneath it. There is a parent/child relationship…
-
How to count children rows with multiple criteria
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status". Each parent row is a different year and beneath each year are cases IDs (these are in the caseregnum column). The cases are categorized into "general" and "special" (this is the type of…
