-
Report in Dashboard won't scroll all the way down
Hi, I have a report I've embedded in a dashboard, which contains 261 rows. The report only allows me (and others) to scroll down to the M's and then a link shows up that says "open source report to view more" and provides a link to the report. I have another report embedded in the same dashboard, but that one allows me to…
-
Dashboard colored panels
I would like to know how to create these colored panels as shown in the Sales Pipeline and Forecast dashboard example on https://www.smartsheet.com/all-about-sales-pipeline-management. I have tried using rich text and title text and metrics and none of them seem to allow for the entire background to be set to a color as…
-
Circular Reference and Blocked Error when running SUMIF calculations
Hello! I'm trying to put sum statistics by using SUMIF or SUMIFS formulas in the "parent" line of each project I have listed. I want to calculate total car miles and costs of each project. When I wrote the formula for the first project, it worked. She below: =SUMIF([Field Site]:[Field Site], "SAN JUAN", Mileage:Mileage) +…
-
Conditional Format based on Rows
Hello Everyone I am currently looking for ways to format my spreadsheet, apparently the conditional format only refers to columns. Is there a work around on this that i could do a format based on rows? link: https://app.smartsheet.com/b/publish?EQBCT=88012ac013044c72a0c6dcb135919a4c thank you
-
Possible to set row level permissions on a sheet so that the requester can only see their items?
We have a sheet where employees can submit a form request. We want them to see their row but not all the other rows submitted by other people. Is this possible?
-
Recommended workflow for testing/updating in one sheet and then moving updates to Live sheet
Here's my current workflow and I know there must be a better way. I have a TEST Smartsheet that matches a LIVE Smartsheet In the TEST sheet I make requested modifications to columns and formulas. Once completed I am manually modifying the columns and formulas in the LIVE sheet to implement the changes. This is way to time…
-
Is there a way to pull only the children into the report?
I am trying to have a report that shows only the lowest indented children in it. I am working on a sheet that has 4 level of indents. Workstream (indent 0), Project (indent 1), Milestone (indent 2) and Activities (indent 3). The report needs to include activities only and not any of its parents. Please let me know if there…
-
How do I add a sheet tame to calendar view when running a report?
I'm working on a production schedule. I have multiple smart sheets for tracking each job's production dates, such as drafting, procurement , production, etc. The I run a report to create a calendar so that I can visually see where each job is sitting on the calendar so that I'm not over scheduling. Problem is each…
-
Verifying a submission done via personalized form
I have a data sheet that is populated by individual forms for the purposes of reporting hours worked towards specific projects., I need to create a report, or ?, that the individual users can run to see what they entered for verification purposes but we do not want the individuals to see all of the entries submitted by…
-
How to setup alerts to notify others, not the one making the change?
Hello, In a sheet where there is an "Assigned to" column that can be multiple contacts. If individuals A, B, C are assigned a task on Row 1 and individual A makes a change to the row, how can you setup the alert automation to inform individuals B and C of the change and not A? Thanks, Casey