-
Locking rows already saved.
Is possible to locking some cells in a row after a collaborator saved? The collaborator will enter information in all cells in a row (this is why cannot be locked before been saved). After saving the information entered, some cells cannot be edit anymore but other cells can be add a value or edit. Thanks. Al
-
How to select one checkbox for a group?
In smartsheet how do I select a checkbox for a group and have it select all checkboxes in that group?
-
AND Condition assistance
I'm trying to have the sheet do the following calculation. If the % Complete column of a project row is sitting at 100%, I want the Status Column to change to blue AND type the test "Completed" in the status column. What comes out when I use the AND condition now, is the following: If % Completed is equal to 100% and <set…
-
Type selected - allows certain columns to be updated
The checklist type smart sheet will be setup with columns called Vendor, Type, Doc 1, Doc 2, Doc3. What I want to do, is depending on the type selected for a particular vendor, the doc columns will grey out for those doc types needed for that specific doc type. For Example: Vendor 1 Type Critical All doc type columns would…
-
Ticketing Sheet: Update Request to Group?
I'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on tickets at different times of day. How do you request an update to a ticket (row)…
-
Automating check box for multiple values
Hi, I need help writing the formula to automatically check the box when any one of these three values is selected: Complete, Cancelled, or Passed_Conditionally. Thanks!
-
Automatically Adding Subtasks
I am working to create a Kanban Sheet and Cardview for continuous projects that we do in our office. We have the same subtasks associated with each client through 3 various phases. Is there a way that when I add a new client or Primary/Parent Task, that the same subtasks are automatically added? Thanks for your help!
-
Conditional Formatting not working properly
Is anyone else having an issue with their conditional formatting not working properly after the most recent updates? My rules have not changed but the formatting is only displaying for some of the rules now. It is mostly occurring for rules that determine cell fill color.
-
Feature Request - Conditional Formatting impropved rule cloning
It would be nice if, when you clone a rule, the conditions do start from scratch when you clone them to the next column. EXAMPLE: If I create a rule that I want to apply to all my columns, then I will clone that rule. When I go in to edit the rule, and select the next column to apply it to, the condition for the formatting…
-
multi criteria for Conditional Formating
Hi, I have a SmartSheet to show the meeting schedule. It has several columns: strata manager, building code,.Supplies given to SM (date) ,Reminder to Accounting department" (this has the formula inside to show the date) I just want to highlight the column of strata manager as green as for the following condition: 1.…
