-
Can I hide the conversations and attachments menu on a view only report?
I have a report where I have hidden the attachments and comment columns and have used the iframe code to embed the view only report in an internal html document. However, people can still click on the conversations and attachments icon in the right margin and see everything. Can that be hidden? Viewer can also right click…
-
Did the report permissions get updated?
I had a report shared to other users as editor - cannot share. With this permission level, they were able to filter and sort the report but now they are not able to. Were the permission settings updated?
-
COUNTIF with multi select dropdown
I'm having trouble with the multi select dropdown option. I have a sheet with the data/responses. I'm creating another reference sheet trying to count the responses. So example, here's my test data. There are multiple options for fruit. In a difference sheet, I'm trying to count the total responses. So Grapes should be…
-
Calculating Number of Tasks above 50%
I am trying to calculate the number of tasks I have in a sheet, which are currently sitting above 50%... this is for dashboard purposes so we can see how many tasks are in the final-closing out stages etc. My formula is not returning any count whether I try it in sheet summary or a separate sheet.... any clues? Result in…
-
Linking two sheets into one master sheet
Ok Here is what I got, I have two employees who work for purchase import section. From Rising the IPO to having the LC created to have the goods delivered to the factory. I have created a common grid header for each of them and they are populating it as I write this. I will then create a master sheet where I will put in…
-
Copy Row Automation - Eliminating Duplicates OR keeping latest Row entry/update
Hello fellow Smartsheeters, I am trying to capture entries from a project level RAID log and pushing them (based on specific criteria) to an Enterprise level RAID log. Specifically, any Risks or Issues that are created and updated need to be pushed to another sheet. I am familiar and frequently use the Copy Row Automation…
-
Calculating how long a query has been worked on and how long it remains at particular statues for
Relating to this previous community query, I've got 2x similar queries.. I've posted it in that conversation but wasn't sure if it bumped it up the queue, so thought I'd post a new thread just in case it wasn't. I've used the formula @Paul Newcome provided in his post to tell me how long since the creation date the…
-
Merged: Easily create recurring tasks
This discussion has been merged.
-
tracking # of employees quarter over quarter
I'm trying to show on a graph how many employees we had in each quarter. How would I do that? My initial idea is to add a helper column for each quarter, and add a formula to return a 1 if any of the date range of that quarter falls after their start date and before their end date, then pull a report counting the 1s for…
-
Crosstab style reporting from Gantt data
Looking for some help on Crosstab style reporting from Shartsheet Gantt data. I have a Gantt project like the below ... How can I produce a report like this one I mocked up in an Excel Pivot table after cutting and pasting and "massaging" the Gantt data? ... Do I need the premium Pivot App (which we don't have) or is there…