-
IF or IF AND Formula conditions DATE
Dear, I appreciate your help. I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019) 1) If the Balance column is equal to 0 (Green) 2) If the Balance column is less than 0 (Yellow) 3) If the Balance column is…
-
Help with Vlookup + date
I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue date + 0. Also if another customer has a "credit" deferred payment type, the due date must be…
-
User attachments
Hi, My team members are unable to attach files under the Individual Plan. According to the Smartsheet features attached, I should have this feature on my plan. Thanks, Kyle
-
A user can't access sheets
Hi, Since last week one user can't acces to sheets anymore. -She can't see old sheets neither new sheets, -She see's the list of sheets she should have access but can't open it -Her team can access -Her count is active, i also activate a licence for her since she report the bug, -We try in private navigation and after the…
-
Disable sharing with free collaborators
For sheets owned by licensed users, is there a way to disable sharing to free collaborators (i.e. only allow sharing with licensed or non-licensed users), either on a per-sheet basis or at the account level (i.e. for all sheets owned by licensed users). Also, I think it would be very helpful to add a "user type" column to…
-
Index Match Values Based on Certain Parent Rows
First, awesome community! I've been looking all over for a solution to my problem, but cannot find anything that would translate to my situation. Hopefully I make some sort of sense describing my issue. Brief: I work for a construction company that specializes in high rise construction. For my department, I'm tracking…
-
Locked out of my account
Locked out of my account. It seems they assigned an administrator to my account and they have locked me out.
-
Can a non-licensed user edit Dashboards?
If I build a Dashboard and add a non-licensed user as editor. Will that person be able to edit and make changes to the Dashboard?
-
Viewer role with the ability to add discussion comments
I have given a number of my colleagues access to a worksheet with the Viewer role. However, they are unable to add comments under Discussion. Is there a way to allow them to do that?
-
Filters for Smartsheet Documents
Hi all, I am looking to add filters for Smartsheet documents. I am relatively new with Smartsheet and have been tasked with creating some documents and reports. We are attempting to model one of our documents after the picture attached (the first one). Here is a synopsis of several goals we are working on: 1.) One of our…