-
Count if project is starting within the next 30 days
Hi, I'm trying to count how many projects will be starting within the next 30 days. I understand I can filter, but i need to run a report and I'm having difficulty with my formula. I'm fairly new with formulas. I continue to receive a "unparseable" error" . Any help would be greatly appreciated. Thank you in advance.…
-
Viewing reports in card view
Is it on the roadmap and what's the likely time frame for being able to view reports in card view?
-
Card View for Reports
All, Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to view user stories across multiple products/sheets. Although there are other benefits I…
-
Card View for Reports
Any idea when or if we will see Card View on Reports in the near future? If not, I'd like to add my vote for this feature as soon as possible; it would be very useful to our workflow. Thanks.
-
If it possible to do vlookup or bulk filter in report?
Hi, I need to filter 220 product numbers in a report. I know I can add each one separately. But is there any way to do a bulk or vlookup filter in the report? I wanted to make a filter with "is one of these" but I can't do that since I can't find a way to do a vlookup in the report. Thanks
-
Bringing in rows from multiple sheets in a report
Hi, How can I bring in specific rows from multiple sheets in a report? Thanks.
-
Filter by Hierarchy
I have a Smartsheet organised by hierarchy, I want users to be able to enter data but only to be able to see their own group (represented as top level hierarchy), my understanding is the correct way to do this is to create a report. But how can I filter the report so it shows a named top level hierarchy and all the…
-
Can you append sheets in Smartsheet like you can power query in excel/power bi
Hi I want to append/consolidate sheets in smartsheet in a master file or separate sheet all the sheets are the same but for different locations im using forms to collate the info because the forms are site specific I want to combine the two sheets below as example in a master sheet and at the same time the master will…
-
Automatic Finish date and Finish time columns for a 3D Printer Sheet
Hello everyone, I am creating a sheet for my 3D Printer and I need some help as I am new in Smartsheet and in using functions. I want to make the "Finish Date" and "Finish Time" automatic, meaning once I input the Start date, start time and duration, the Finish date and finish time will automatically show when my 3d print…
-
Progress % in dashboard
I want to add a widget in my smartsheet that shows how close we are to hitting our target based on a summary total. For example, our target is 200 and the sum total from another sheet shows 100. I want a to show that we are 50% of our goal. Any Idea how I would do this?