Is there a way to highlight rows using Conditional Formatting when it's past a number of days?
Orange when it is 45 days after "Date of Visit"
No. I would add another column and have it add 45 days from the date of visit and then do conditional formatting based on that. Does that make sense or would you like an example?
You can do the following:
1) Add a Column called "45 Days After Visit" and make it a Date column in the column properties.
2) In the top cell of the "45 Days After Visit" column, enter this formula:
=[Date of Visit]@row + 45
3) Copy and paste the formula so it is in each row of the "45 Days After Visit Column"
4) Create the following Conditional Formatting rules:
Column "45 Days After Visit" "Is Today" and
Column "45 Days After Visit" "Is in the past"
Format: Orange background color for the Entire Row
5) Hide the "45 Days After Visit" column (optional step)
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
I have an automated workflow that requests a form if certain fields are blank. It's triggered when a new row is added or changed. More specifically, the automated flow is activated when a required field is added or changed. This works fine. However, the automated flow doesn't issue a follow up form request when some of the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.