-
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…
-
Help! With finding a formula!
I created a monthly bill sheet for work, that has colums for every friday to keep track of bills. On the top row, It adds together the total amount due for each week. Below that row, I am trying to add a "Paid" row that will subtract what is paid from what is due to always have an updated amount due. By either turning the…
-
Any experience with Aha! ?
Hi everyone! Our internal idea requests and other details live in Aha!. I'm beginning to look into exporting this data into specific Smartsheets. I am able to export from Aha! via Excel and then can utilize those files to import into Smartsheet. Does anyone have any experience with this or any tips for working between…