-
Is there a better way to get the results I am looking for?
Good afternoon, all! I have been tasked with creating an in-depth catalogue of SKUs for my company. Currently, I have a set up that works but is going to be very manual with change management. I have one sheet that is my data dump. It has all of the information located in one spot. I am then going to need to pull this…
-
Count how many times a multi-select value was selected in a cell range or column
Hi, I am trying to count how many projects from another sheet has a specific OKR value selected in a multi-select dropdown column. Example: There are 4 projects, all of which could be assigned to a single or multiple OKR values. I need a formula to count the number of times, e.g. 'Improve Operations Efficiency', was…
-
Sum by Month in Report
I have a report created from 19 sheets - these sheets have delivery dates and project values. I want to sum by Month. See screen shot of what I have so far. I can't get it to sum, September, October, November and December independently. HELP
-
Allow sending multiple rows from a Report (without redirecting to the source sheet)
Currently, when working with Reports in Smartsheet, it is not possible to send multiple selected rows if they come from different source sheets. Also, when sending rows, the recipient is redirected to the original sheet instead of seeing the content directly. It would be very useful to: Select and send multiple rows…
-
Multiple Entries of The Same Name Into A Single Row
Good morning, I am newer to Smartsheet so forgive my lack of knowlede. I have created an attendance tracker form to track employee call offs from for our supervisors. Is there a way for example if John Doe calls off 3 days but each day is a separate submission due to different supervisor working, if each of John Doe's call…
-
Why is report showing Target Date as a Formula and not allowing adjustments?
Good Morning! My master sheet has a Target End Date column that is formatted as a date column. For some reason, on my reports, it is now showing this field as a formula value and not allowing updates directly from the reports. Does anyone know how I can correct this? Thank you! Julie
-
Enable Attachment Access from Report Widgets on Dashboards
Hi everyone, We’re working on streamlining our grant review process using Smartsheet, and I wanted to share an idea that could really improve the reviewer experience — especially for those who aren’t super tech-savvy. In our setup, students and faculty submit grant applications via a Smartsheet form, including attachments…
-
Adding Calculated 'Report' Column into a Report
we need to make some calculations on summarized data in reports. such as summing up two or more column values or dividing two column's values in each other to get a percentage value from them. Calculation have to be functional not only in data rows but also in summary rows in a report. My suggestion is to make a calculated…
-
Dashboarding Annual Calendar: Best Practice
Trying to develop a calendar/dashboard to reflect the major milestones of all projects happening in the PMO and having a difficult time! I haven't been able to find a dashboard visualization that easily displays all projects at a high level with callouts for project milestones.. I tried a timeline widget (see image below)…
-
This is a question about multiple selection able to run report and auto counted and group in report
I asked this question before, but hope things might be updated, we currently only can run report based on a single section in the column, correct? or can we run report in multiple selection