-
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.
-
Field Service Management in Smartsheet
Has anyone built a Field Service Management solution in Smartsheet? I need to maintain a database of; store locations technicians, their backup tech and their backup of the backup tech dynamic schedule of availability of said technicians I envision some form of a 'lookup' worksheet where appropriate and relevant data from…
-
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"…
