-
Copy row without formatting
It would be very helpful if the automation to copy a row from one sheet to another could be done without the formatting going along for the ride. It's tedious to have to undo formatting from the source sheet in the target every time a row is added.
-
Merged: Copy Rows Without Formatting
This discussion has been merged.
-
Logic for Required Fields on Forms
I have a form that I am working on where I would like this logic: If box is checked, then field is required I spoke with support and they informed me that this is not a currently available feature. What I'm trying to do on my form is have it so if the user checks a box that they want someone to reach out to them, then they…
-
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…