-
Merged: Is it possible to simplify the process to set-up a reoccurring task?
This discussion has been merged.
-
Need help adding a 3rd argument to a COUNTIFS formula
Hello, I am trying to count number of late documents within a specific section of the sheet. I have been able to do it successfully using row numbers but we change rows frequently because it is a roster type list I don't want to have to edit the formula each time. The third argument I wanted to use was to use their teams…
-
Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
-
Why is Dynamic View allowing me to build logic based off one set of dropdown values but not another?
I have a Dynamic View built from a report of multiple sheets. I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here: But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values…
-
Conditional Formatting for SmartSheet App
Currently there isn't a way to color code cards/line items in the SmartSheet app. This would be a huge help for triaging tasks to the correct group as its easier to identify a color than a small text on a handheld device.
-
One Conditional Formatting Rule Not Taking Priority
I apply a similar strategy of conditional formatting to a lot of sheets and don't usually have any issues, but on this one sheet, I have a rule that's listed above the others, but it's not taking precedent over the other formatting rules and I'm not understanding why. I have a cascade of blue colors to denote "header"…
-
Conditional Formatting Gantt Bars & Other Columns
Currently, if conditional formatting is applied to Gantt bars, the format must be applied to the "entire row". I would like the ability to apply conditional formatting to the Gantt bars and additional formatting to individual columns. Example: format Gantt bars red, yellow, and green for large, medium, and small impact…
-
How do I set conditional formatting, based on dates, to span across columns representing quarters?
Hello! I am trying to create conditional formatting based on a range of project dates that will fill cells representing quarters. For example: if the project spans 5/6/24 - 9/1/24, I want it to shade the Q2 24 and Q3 24 cells. If the project spans 5/6/24 - 1/5/26, I want it to shade cells Q2 24 through Q1 26. See the dark…
-
CountIF for a multi-select drop-down
Hello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because it makes the most sense for me. In the sheet summary tab, I want to be able to count how many rows need…
-
Conditional Formatting Not Working as expected
I'm trying to apply conditional formatting to a sheet and it looks like it's ignoring the conditions that I've outlined. First, when you apply more than one condition to a sheet it's an AND and not an OR, correct? Second, these are the conditions I have set. When I have both conditions enabled AND the date is in the next…