-
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…
-
one time change cell
Hi, There I would like to know if It is possible to freeze a column one's validation is given to make sure no more modification can be done. Thank you,
-
Autofill Date Column with Conditional Formatting
Hi there, I am trying to set up an approval sheet. I would like my "Due Date Column" to auto fill a date 3 days before the date in my "Date" column only if my "Completed" check box is NOT completed. Can anyone help me with this formula? Thank you
-
Auto Number Columns Based on Other Column Input
Is it possible to link the auto number format to data in other columns? For instance, if the user selects a particular product type in a form (Soda, Water, Juice), can I create an auto number column format that looks like Soda-001 or Juice-001? Thanks
-
Hiding completed rows and showing all rows easily
I have several sheets with rows that are "old" (completed, sold,...) and that I want to hide most of the time. Conditional formating does that well. But I need sometimes to see them all. How to achieve this easily?