-
#Blocked column on report
I'm hoping someone can help with this infuriating problem I'm having. I have 4 columns on a sheet that I use to help me find which working week a job is due. see below. However when I add them to a report or try and filter these in a report I get the below error. Does anyone know the reason for this?
-
COUNT(DISTINCT(COLLECT - Counting a value per employee
Hi, I'm trying to count how many values I have for certain people. I have two values that are assigned to the employees daily, for each day we have a value of either "Y" or "N". I want to count how many "Y" an employee has. I'm getting this information from a big database, to have it summarized in a small one. I've tried a…
-
Show Attachments on a Smartsheet Report
I have an ask from our management to highlight the sign-off of requirements for our projects. In our current state, our team uses a fillable PDF that is signed electronically by our stakeholders and then attached to the corresponding row in the Project Plan sheet that contains the milestone for sign-off. I am being asked…
-
Proof Tracking
Hello! I am pretty new to smartsheet. We are trying to use the proof function to gather approvals on our projects. We have several different projects working at the the same time. Is there a way to create a report to see which proofs have been sent and which have been approved?
-
Locking report settings
Is there any way to lock a report's settings once it has been set up ? I can't find anything in Smartsheet about report settings and have some concerns inexperienced people may go in and accidentally change things.
-
Automation and Task Re-assignments
It would be nice for an Admin to be able to: (1) see, or run a report for, the automation workflows a specific user is attached to; and, (2) selectively edit and reassign automation assignments and tasks to a new user based on a pre-existing user (for example, when a person leaves an assignment group or company).
-
Data Shuttle - Need to filter new hires within last 30 days
Hi everyone, I'm trying to set up a Data Shuttle offload that will export the following information into OneDrive: Employee Name Role Manager Employee Type Hire Date The problem I'm running into is that I am not seeing any viable way to filter the results within the last 30 days. I setup a report for this as well but…
-
Summary Sheet/Report/Cards/?
I have no idea how to even approach this. I have played with using a report summarize some data using different views, but the formatting so limiting that I cannot get anything useful. I have a main sheet that tracks evaluations. For this summary I want to show just a small bit of data. I have columns that I want to use in…
-
Dropdowns in a dashboard, is it possible?
I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total sales for each month, and even quarter, down to how many projects they have completed…
-
How do you apply text wrap to the sheet name column in a report?
Since this is not a column from the underlying sheets, but rather a system-generated field, is there a way to apply text wrap to this column in a report?