-
Reports (no longer slow to refresh)
Seems like reports are refreshing super fast now. This has always been a huge problem for me because I refused to use smartsheet live in a meeting because reports were just so slow to load. I'll admit that part of the problem is probably my design (pulling data from up to 150 files). Fingers crossed that fast reports are…
-
Report w/Current User and Dashboard interaction
I have created a report with the attribute of Current User; when I added this to a Dashboard - it appears that functionality with the report is lost. When going to the dashboard - the report still reflects my assignments; the current user function within the report works as I tested it within my group; is this a known…
-
Formulas for an automatically generated Risk Level
Hi I'm am trying to replicate the below formulas in smartsheet so it can automatically calculate the Risk Level with existing controls and with additional mitigation. The below formulas are currently being used in excel: Formula for existing controls Risk Level: =IFERROR(VLOOKUP(H7&I7,LikeliConseq, 2, FALSE),"") Formula…
-
Power BI
Hello, When a sheet is updated in Smartsheet will a report in Power BI automatically read that update? Without having to wait a day to refresh or having to reload to Power BI online, etc. Thanks!
-
Help with rollup sheet structure and formulas
We have contractors that we pay every 2 weeks. I created a form for them to upload invoice info into. I also created a report that pulls the individual invoice totals. What i want to create is a rollup sheet that will give me a total of that week's invoices for a given contractor. So for instance...Total invoiced amount…
-
Multiple Check Boxes in Cross-Referenced IF Statement
I have a master spreadsheet that details the progress of a project. I'm in the process of rolling all the information on that sheet into another that consolidates anywhere from 1-100 lines (check boxes) into a single line. The example below shows an example of 3 check boxes. That being said, I'm creating a formula for a…
-
Scheduled export of sheets
Hi there. I'd love to see a feature implemented whereby a scheduled export of sheets could be set up. I'm thinking in particular about project plans but this could apply to any sheets. We have a team subscription but we don't need to set weekly backups of entire workspaces, but I would love to be able to set certain sheets…
-
Pivot: when more than 1 variables in columns?
Current design of Pivots allows to have up to 4 variables in Pivot table rows, but only 1 in columns. Will it be possible to enter more than 1 variable in columns? When? Thank you
-
Question about the Resource Allocation Feature
My team has a master project list for the year. Some of the projects include ongoing projects (newsletters, web maintenance) that we marked as a due date of 12/31/19. Others may take a week or a month. When I turned on the resource allocation tool, I noticed that everyone was majorly over allocated. Would the ongoing…
-
Report access without sheet access
I have a sheet with a lot of information I want a particular person to be able to access a subset of that information. I therefore created a report which includes exactly what i want them to be able to see. I tested sending a link to the report to an external address but when i log in as that external user all i see is a…