-
How to auto-create a new set of rows once criteria is met?
Hello, I want the following columns to auto-create (with the filled in colors as well) below the already created ones every time "SITE" gets filled in. Do I use a formula, conditional formatting, or some other way? Thank you in advance for the help!!
-
How can we have a drop down in Dashboard
Hi Team, How can we have a drop down in Dashboard My objective is - Say for a example a user want to see just the input related to his/her project he can filter his project from dashboard and view. Thanks
-
10 Auto Rows Automatically Have Green Cell in Status Column In Smartsheets
Hi! We have 10 blank rows on our orders page in Smartsheets. Those 10 rows have a cell under our Status column that is automatically highlighting green. I've checked conditional formatting and don't see anything out of the ordinary. I've looked for hidden columns, but don't see any. I've tried to manually clear the rows,…
-
Card view: can I make color changes persist?
Is there a way I can make manual color changes persist? I cannot find a conditional formatting rule that overrides manual color changes, so it's a mystery to me why my team's changes disappear. Thanks for any advice or guidance!
-
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…