-
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.
-
Limited Access to Report Builder
We have been using a very simple report to pull information from a single sheet. The report has been working fine for several months. Today I was notified (& verified) that I am the only person who can still edit the report via report builder. Everyone else is stuck viewing the information I last searched for and cannot…
-
Printing forms
Hi, There any form created on smartsheet set a collumn to each form field. So in case a have more than 7 I probably will face some width issues during printing. is there any mask (or any other path) that I can printing the sheet form information on the same form layout?
-
Dependencies on GANTT view
Hi, I am struggling to get sub tasks report as I think they should. Example in screenshot. Basically, if I have sub tasks, then I want to have the heading task report the last date when ALL the tasks are complete. At the moment, by default, the main task shows when ANY date is entered in "Finish" which if sub tasks are…
-
Alerts & Action notification
Hello, I am trying to modify the Alert&Action notification which I receive when someone updates the sheet via form. This sheet has around 50 columns which need to be updated, and form updates them regularly. However, I would like to receive a short summary of the 15 fields of most interest but it seems that notification…
-
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…
-
Copy/Paste Text Into Edit Window - Calendar View
Working from calendar view - when editing rows we are unable to copy/paste text into our "comments" field. We are only able to manually add text. Same for editing rows from the search option. We often have a large amount of text to add there, so the copy/paste function would really help. I hope this makes sense.
-
Removing a licensed user
We have 3 licensed users. One of the users left the company and is no more accessible. We would like to move his license to another user, and move the ownership of all his sheets to another user too. I am one of the licensed users. What should I do first? move his license then move the ownership of his sheets? or…
-
More #UNPARSEABLE problems
Hi all I have no idea why this is not working. Here is the formula that I am trying: =if([Opportunity Stage]1="Lead - Qualified",5%,if([Opportunity Stage]1="Scoping Requirements",10%,if([Opportunity Stage]1="Proposal/Quote/RFP Presented",25%,if([Opportunity Stage]1="Contract - Legal Review",40%,if([Opportunity…
-
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…