-
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?
-
Setting Conditional Formatting/Formulae(?) for Red Yellow Green balls based on % Completed
Hello, I am trying to have the Red, Yellow, and Green status balls automatically change/update based on the percent completion of each row task. When I click on the conditional formatting button in navigation pane and make new rule of, "If % Complete is between range of 1% and 99%, then change the status column to Yellow"…
-
Gantt Chart Task Percentage Color
How do you change the color of the percentage indicator inside the bar of an individual task? In conditional formatting, you can only change the color of the task bar itself and not the color of the percentage of the task. Thank you.
-
Can I attach a document as help text in a webform?
Hi there, I need to include a budget template in a webform I created. My initial thought was to embed a link to the template, but it does not appear to be possible to put a hyperlink in a Smartsheet webform. Can I attach a word doc/excel spreadsheet to the webform help text somehow? Best, Molly