-
Comparing Columns
Hi, I feel like there has to be a simple way to do this and I'm just missing it. I have an inventory report in Smartsheet. One column is the available quantity and another column is the reorder point. Is there a way to highlight the available quantity if it is below the reorder quantity? Thank you!
-
Is there a way to only have one attachment visible on reports?
I am wanting to make a report of certain project details/agreements for another department, however I am only wanting them to have access to the fully executed agreement (one document/attachment) and not all of the supporting/additional documents that are attached. Any ideas are greatly appreciated!
-
Formulas in Reports/Reference reports for Dashboard
I read in the community (the posts were a few years ago) that you cannot enter formulas into reports or that you cannot reference reports for a dashboard. Is this still the case? I having living data that really needs to be manipulated to get it prepared for a widget. I'm new to smartsheet and it seems like reports are the…
-
Meeting Minutes Crossover/Linking
Hi, we have numerous live projects at any one time, e.g. Project A, Project B, Project, C and so on. We hold weekly Project meetings on each project and keep notes and assign tasks in a Project Meeting Sheet. Separately to this we hold other a number of other meetings such as Design meetings, Production meetings, etc where…
-
Choosing a Task List vs a Project
So, I have a question that on the surface might have obvious answers but want to think through the potential implications for choosing a Task List vs a Project. In theory a Project should have a defined start and finish for all tasks. A Task List essentially becomes a "to do" list. Tell me what I might be missing please.…
-
Advanced Filtering by MAX value
Hi all I've created a report and wanted to know if there is a way to show unique rows by the highest date value For example - below I would like to see the bottom table as my report (colours are just to show the matching rows - they are not part of the conditions required) where only the unique rows are pulled through…
-
Need help with creating report(s) with data from a Survey
Hello, I am still fairly new to Smartsheet and need some help turning around data from a survey I sent out. I have 600+ responses that I used the Request an Update function in Smartsheet to obtain, that I now need to summarize and I have no idea how to start the summary process. The survey is regarding Security Services at…
-
Reports & Proofing to Person outside Organisation
Hello, we are outsourcing some drawing to a freelance CAD Technician outside our organisation. I have setup a Report that has a number of source sheets and have added a checkbox column in the source sheets if the drawing is to be outsourced. When checked that item shows up in the Report (for all internal organisation…
-
Using "Current User" functionality
Hi Smartsheet Community! I have trouble utilizing "Current User" in report. This is my Grid. "Assigned To" field is mapped to user names, using "Contact List" as column Type Yet when create a report with this column, filter would not show "One of" as filtering option. Hence I won't be able to select "Current User"…
-
Current User Views on Reports/Dashboards
Hello! I am trying to create a dashboard for internal, unlicensed users to see tasks assigned to them, and I seem to be missing something because I can't get it to work. I have a report filtered to current user: I have the report on the dashboard set up to show the viewer's data: I have the user shared as admin to the…