-
Web forms, is it better to add at top or bottom
I have been using web forms to populate existing sheets with new data. But I have a question as to whether it is better to have new data at the top of the sheet or the bottom? 1. I see that updates are referenced by row number, so if I have data come in and an update request is sent out. And then new data is added at the…
-
Best way to append text in a cell?
Hello, We have a project tracking sheet into which people will be adding status updates to a particular cell. Is there a way to easily append the text to the previous text so we can retain history? People can use "Alt-Enter" to create a new line but then cells get very large. Is comments the best way to do this? People…
-
Conditional Locking
Is there a way to lock a row based on criteria in that row? For example, I want the row to lock if the "Tier" column is a "2" or "3." Thanks.
-
Microsoft Office 365 ATP Safe Links issue
Hello Smartsheet Community, Has anyone experienced issues with Office 365 threat protection scanning links when opening Smartsheet approval forms or update request forms sent from https://app.smartsheet.com. See the Microsoft link below for an example of what our users are receiving. Unfortunately, this has slowed down…
-
Combining IF and AVG help
Hello, I am trying to combine these two functions to find an average number but only if it meets a specific criteria. For example, I have cases worked that can be canceled for 3 reasons. If the case is canceled because of a "No contact" with the client, I need to know the average number of days the case was active before…
-
Problem with search bar
I type text in search bar, but the search function doesn't pull the information, even though its in a sheet. I have cleared any/all filters. Not sure why it won't pull the information. It's clearly in the sheets. I screenshot information in one of the sheets in question. I also showed the search results not pulling the…
-
Excel Import Truncates My Index Column (Strips all Numbers except 1st one)
I am a brand new user...I imported my resources into a sheet using an excel import. My Index Column was truncated, any idea how to reverse this or stop it from happening?
-
Is there a way by which users can only view their rows instead of having rights to view other users
Hi All, Is there a way were a user can just view and edit his/her rows and he/she shall not be able to view other user rows. Example: Attached screenshot.I have two contact David and Charles. Now, If David wish to update his data on the sheet he would not be able to view Charles rows vice versa.
-
Resource management at the project level?
Hi, From what I gather about Smartsheet's resource management feature, I can show which users are allocated (and over-allocated) given how they're assigned tasks in a project. I'm wondering if Smartsheet can do a higher-level allocation synopsis, whereby I can see simply that someone's completely allocated as a resource…
-
Do Filters Work Correctly?
I created a filter that: * Shows rows that match <all conditions> * <Status> <is not one of> <3 values selected> (DONE, DEAD, LATER) * <Archive> <is unchecked> The instructions my team is getting are that they can flip tasks to DONE and DEAD, but they won't be hidden from view until our next meeting where they are then…