-
Alerts
How do I change a row color if project is past due
-
Forms
I need data to land in particular areas when entering into a Form... In my sheet I have Hierarchy's...Months, Jan through December. Under those sections I need the orders that are entered into a form to automatically be put under each area according to the date...thoughts??
-
Conditional Format For Cell When Cell Is "Sheet Link from Cell in Other Sheet"
I am trying to setup a Conditional Format formula to format a cell only when the cell contains a linked value of "Sheet Link from Cell in Other Sheet"
-
linking two columns togther
Hello Everyone, I have two columns, one has the name of the customer "name" and the other column has the number we assigned to the customer "number". I am trying to link these two for example, let us say if I type 111 in the number column the name joe will appear in the name column, and the other way around. If I write joe…
-
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!