-
Resource Report View
Wondering if there is a way to create a resource view that is more of a traditional calendar view?
-
Cannot Import the filtered report or the report created to Power BI or Spreadsheet.
Hi Team, We love the features of Smartsheet. But to make it more effective and have a bigger user base, this Product feature is definitely needed. For instance, I need to export the results of a Filtered report to a Power BI Dashboard. I have the necessary connectors. But there is no way I can just extract the data that is…
-
FILTER A REPORT ON MOBILE APPLICATION
Hi, I am interrested to know if we can filter on report on mobile apps. I explain, on computer we have the possibility to choose filters by Where, Who, What, and/or. It is really helpful to have an activity follow up linked to many sheets. On mobile, for the same report, I don't find the way to do it. Do I miss something…
-
Finding Duplicates
Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of getting duplicate information from the outside source. Once imported from Excel into Smartsheet is there a way to fnd & delete…
-
Multiple Allocation % per task
Wondering if there is a way when adding multiple resources to a single task to add also multiple allocation percentages? For example if i am tasking A & B on task 1, but i want A to be at 20% and B to be 50% - is there a way to do that without creating a duplicate task line?
-
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…