-
Conditional Formatting- Color Change
I am needing to add conditional formatting to my sheet to change the color of a row if it was added within the last 30 days. How do I do that?
-
how to set up info sheet to feed into Resource Management
I have entered this data and am using it as a way to track allocations across different projects. The different projects are indicated by the different WRT #s in column 1. I need to then summarize the last 2 columns by WRT #, which I've done here in a report. I am wanting to add some type of flag or conditional formatting…
-
How many would be interested in more visual customization in sheets?
A primary use case for Smartsheet for my department currently is what we call Selection and Segmentation. Essentially we crunch a bunch of data about influencers in a particular field and match this data to the goal of a company we consult for. We then suggest a pool of candidates for the company to focus their efforts on…
-
Merged: Copy/Paste Conditional Formatting
This discussion has been merged.
-
Conditionally Copy "Modified By" value to another row cell
An update to a column called, "FOO", should trigger an event where the contents of "Modified By" are copied to a column called, "BAR". Steps. 1. I change the contents for "FOO" from 'a' to 'b'. 2. "Modified By' changes to my email (the usual automated way) 3. My email is copied over to "BAR" **If a field other than "FOO"…
-
Highlight parent if child task is in the past
Hi I have a sheet that has a column called Task name it has a main task with 4 subtasks (child) below it. The sheet has a Task name, Status and due date column. If the 1st sub task due date is in the past and not marked complete how do I have it highlight the parent of this task Red. If the 1st is complete it is no color…
-
Equipment inventory log
I am trying to create a workspace with multiple spreadsheets that will transfer rows back and forth from one to the other automatically. I have a sheet for inventory, one when the equipment is assigned to someone, and another to archive any movement. I have a form that they fill out when assigning the equipment out which…
-
Merged: Persistent custom colors
This discussion has been merged.
-
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…