-
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…
-
Count "green balls" within a range
Hello I'm am wanting to count "green balls" within a range. I have used =COUNTIF([Site Attended]11:[Site Attended]26), "green") I'm have the result #unparsable I am a new user so would apprecate the help. Thank you
-
Reverse Engineering a Timeline
Is there an easy way to reverse a timeline that was originally based off of a start date, but should be based on the end date? We plan a lot of meetings where the meeting dates are always moving and we want to adjust the way we have our timelines so we can change the meeting date and Smartsheet can fill in the dates of the…
-
Web Forms
The only way that I know to add an attachment accessible to the user is to create a link. (I'm not referring to the user uploading a document to the web form.) Is there another option?