-
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…
-
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…