-
Incorporate two data sets in one if/sum statement.
I have one column where I want to sum the total amount of days of work, however, I want the sum column to be dynamic based on the %Complete column if the percentage is <100%. I want the Sum column to show a total value anytime the % Complete is less than 100%.
-
Conditional Formatting on Parent Line
I created conditional formatting that allows me to color code based on % complete of child tasks, however this does not carry into the parent line as I have dependencies enabled. I would like to be able to visually show the progress of a project based on the average of the children status on the parent line.
-
Feature Request: Multiple column selection in Conditional Formatting
I have a customer that wants 7 columns to be the same format when a single condition is met. I would like a multi-selection option for the "Select what to format. This may even result in a performance improvement for this use case. Craig
-
Create dependency reminder by date
I'm looking to create a content tracker that includes a reminder to review once a document has reached a certain age. For example, Content piece one contains a column for "publish date", once 6 months have passed since that date, I'd like a status column with options of "current, needs review, outdated" to reflect status…
-
Autonumbering does not always work?
Hi there I have an order reference column set to auto number. It is prefixed by the date and then an autonumber for the order on that day. For one user the autonumber does not always seem to work, if he creates a new line it uses the same number as the line above. This means we end up with two identical order numbers. For…
-
Formula using both an IF and SUM(CHILDREN()) parts
Hello people I would like the cell in [Total]5 to show the sum of all its children, but only if the [Qty of Tasks]5 cell is empty. If [Qty of Tasks]5 is not empty, then I would like [Total]5 to show =SUM(Tender5 + Variation5) I have tried =IF([Qty of Tasks]5, "", =SUM(CHILDREN()), (Tender5 + Variation5) * [Qty of Tasks]5)…
-
Conditional Formatting at Sheet Level - not row/column specific
Hi there knowers of knowledge, Is there a way to set conditional formatting so that across the sheet if the condition is met the format is applied. Think: if sheet contains 'YES' apply this format, across the entire sheet. Thanks!
-
Conditional Formatting Changed Over This Weekend
I've got a development backlog I keep in Smartsheet. Many of my checkbox columns have conditional formatting - red when not checked - normal when checked. I have header rows that I inserted a period "." into and changed the font color to match the row to hid the conditional formatting. Now, the conditional formatting is…
-
Misc feature requests
The following features/enhancements would be useful: * -Card view also for reports * - Conditional formatting applied in reports * - BOX task integration (tasks assigned in BOX could be displayed as a separate report) * - Reports from reports, not only from sheets. This would enable more advanced filtering * - A report…
-
Conditional Symbols $ to $$$$$
Hi All, I went looking for the below but did not find it, so i built it. Use the below for a 1-5 symbol column like ($-$$$$$) to conditionally set the value based on a column in your list. =IF(Saving1 = MIN(Saving:Saving), "One", IF(Saving1 = MAX(Saving:Saving), "Five", IF(Saving1 = AVG(Saving:Saving), "Three", IF(Saving1…
