-
Date in a CountIf formua
I want a calculation that displays a summary of how many records have a complete date greater than or equal to 1/1/2017. Here is what I add to the cell: ="Unassigned: " + COUNTIFS(LOB:LOB, "ERx", [COMPLETE DATE]:[COMPLETE DATE], >=1/1/2017) Then I get an "Invalid Operation" messag and SS adds spaces to the date portion of…
-
Export List of People a Sheet is Shared With?
Is there a way to export a list from a sheet that shows the user's security level? And if so, can this list be imported to a new sheet so that each team member does not have to be added manually to the new one? This is not necessarily for a template that is used repeatedly. It is a group of about 150 people, various…
-
PDF exported report includes comments even though not indicated
Hi there, When trying to export a report I built as a pdf I keep on getting the content of the comment column too even though I have left the box for this option unticked. What can I do so the report exports into pdf without this column? Many thanks, Lesley
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Reports including values that should be excluded
Hi there, I am building a report and when I indicate I want the "What" to include all values below 100%, the report still includes the 100% tasks as well. I have tried to entered the in between 1-99 and 0-99 values too buit it still spits out a report including 100% martked takss. I feel a bit puzzled by this. Can anyone…
-
Feature Request: Foreign Servers
Not a server guy, so if I use the wrong words please try and understand what I mean above what I say. Why not have some “mirror servers” in Europe and in Asia so that users in these countries can more rapidly access their workspaces. So, we use SS worldwide. In Russia, China, Japan, Netherlands, England, France, Belgium,…
-
Hyperlinks reformatted
I have found that when I import an excel sheet that has a hyperlink to one of my test procedures, it appends the link with an extra “.0”. For instance, one of my test procedures has a document number "75895", and it has a hyperlink to a website that will open document number "75895". The problem is that when I import this…
-
How to organize smartsheet for multiple column updates monthly
I would like some suggestions on how to use smartsheet for my application which collects data for a metric. For my application, I have 50+ projects that are spread across multiple businesses. For each project, each month the owner needs to enter 4-5 data values to report the monthly metrics for their project. We need to…
-
Amazon Web Services
Is the S3 vunerability patched yet so that we do not have a repeat outage like we did at the end of February? Or are we still at the mercy of AWS?
-
Feature Request: Timesheets / Time Columns / Time Trending
What we want, is to be able to generate a daily or weekly report of how much time each person worked, and on which tasks. We need to be able to not only see the efficiency of the tasks, but also of the people. And if we can select a specific period of time, this would also be useful. I have a project where each row has a…