-
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.…
-
Conditional Formatting Not Working
These conditional formatting rules are not being applied to my sheet for applicable rows. Does anyone have suggestions?
-
Conditional formatting if task is behind schedule
Hi guys, I'm new to Smartsheet so forgive me to ask the question. How do I setup conditional formatting to a task that is behind schedule? I created 2 lines of conditional formatting already: 1 ) task is 100% complete -> green row 2) end date is in the past and % complete is not 100% -> red row I'd like to add a third…
