-
Conditional Formatting
I am trying to add conditional formatting to a Date column so that it goes red if the date is -90 days ago or older from today but the conditional formatting (below) is only formatting -90 days from today as red. Today date 24/10/2024 minus 90 days is 26/07/2024. I need every date before 26/07/2024 to go red and every date…
-
Conditional Formatting Comparing Dates
I want to have conditional formatting comparing 2 dates: Where [Actual] > [Due Date], column will be red Where [Actual] < = [Due Date], column will be green Where [Due Date] has a value but [Actual] is blank, I would like to assume today's date for Actual. Where [Due Date] is blank, but [Actual] is not, I'd like it to be…
-
Collapse When Completed
When the completion marker (ideally configurable based on a selected column) is "complete" the hierarchy for that parent item should collapse to free up space since those child items are no longer part of active work. This would make long-running projects/sheets much easier to manage by displaying only the active work…
-
Combine "AND and "OR" with filtering
I did not see this topic covered: Is there a way to combine logical "AND" and "OR" when creating a filter? The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR) Here is why I am asking: I want to filter a buzzword that some people put in the "Comments" field and others put in the "Suggestions"…
-
Showing multiple dates from the same sheet row in a calendar
I have 6 columns in my Smartsheet that are date columns, two of which are start and end dates. I have got the start and end dates to appear in a calendar report, but the other ones (individual dates, not date ranges) do not show up. I cannot have them as children rows. I have tried applying conditional formatting to the…
-
Task Health Indicator Formula (IF/AND/OR)
Got burnt out looking for my exact scenario in the forums, so looking for direct help. Trying to create a formula to automate my Health column KPIs based on task status and assigned dates. Status options: Not started, In Progress, Blocked, Complete Desired Status Colors Blue: Status = Complete Red: Status <> Complete AND…
-
Conditional Formatting Reports in Dashboard
I created our organisation's Risk profile in Smartsheet with a dashboard with reports in it, the reports have conditional formatting to highlight those high-risk areas. I have to print this dashboard to be uploaded to Boardpro for our board but the colours will not print. Is this going to be resolved anytime soon?
-
Form Logic
Hi! Needing help with conditional logic within a form. So, I built a form for Training, Travel & Development Requests within my organization. With that, I have built in approvers (the associate chief operating officer is a drop down to select the applicable approver). What I want the form to do is: When a submitter selects…
-
Merged: Referencing a range of cells in conditional formatting
This discussion has been merged.
-
COUNTIFS for Escalation Tracking
I am looking to create a formula that counts the how many times over the last 12 months escalations of a certain deal size occurred. Deal size is represented as range of AUM in text format. The current formula I'm using is =COUNTIFS({Escalations Range 1}, "75M - 150M", {Escalations Range 2}, >TODAY(-365)) I created a…