-
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…
-
Showing weekend dates with conditional formatting
Hi there, Is there any way of showing weekend dates with conditional formatting? I would just like to add this to my schedules, so that when they're being updated, any dates that knock on to a weekend are highlighted for me. Note: some of my suppliers work at weekends and some don't, so I can't just change my settings to…
-
Formula return Column date plus 7 days IF column value is less than 3
Hi, I am new to smartsheet (spreadsheets in general) and I am trying to create a task list sets a due 7 days after a task was created if the priority of that task is less than 3. The formula i have so far is: =IF([Priority]1 < 3), [Created]1 + 7 I get an error saying Missing or invalid parameters. I'm not sure what im…
-
The Time it Took to Perform a Particular Action
Hi, I realize the questions is quite vague, but is there any way to show/calculate (this need not necessarily be done via a Report as the word is used in Smartsheet terminology) the time it took for somebody to complete a certain action. I,e. let's say there's a task that somebody is assigned to and they begin this task by…
-
Highlighting changes on a sheet
If I highlite changes done to a sheet for me within the hour or so, will this rule show up for others or does everyone need to setup this highlighting feature themselves?
-
RYG balls based on task completed
I have a sheet where I want to update the next columm based on the RYG color of the first. For example: If Column 1 = Green then I want Column 2 = Blue I think I am close on the formula but it just isn't playing nice. Thanks!
-
RYG balls based on dates of activities completed
I have been following some threads discussing how to use RYG balls in conditional formulae based on a date column (i.e. green if the date is in the future, yellow if it is today, red if in the past, etc.), and those are very helpful! I would like to do the following, however, and I cannot find a thread that addresses this…