-
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…
-
Data Values Not Scaling
Can't figure out what I'm doing wrong. The horizontal axis won't let me scale to data values - option is grayed out so all the values are pushed to the top. In the first column the 86 should be in the blue, the 7 is for the red and the 30 should be in the orange. The vertical axis allows for scaling but it doesn't do…
-
reporting on update requests
Hi all, Every week I send out update requests. I get the notifications when someone makes a change but I was wondering if there is a way to actually report on the update requests sent out and which have actually been done vs those that have not been complete???
-
Automation, Reports and Projects
Hello, I'm trying to find a way to automate my Reports. I want to create a Report that uses an entire folder under Data. So that when I add a new sheet to that Folder the Report automatically updates and I don't have to modify the Report after every new sheet. Another automation I would like to do is create a site…
