-
How to change Gantt chart background color
Hi all, I used a Smartsheet provided Gantt chart template for projects. The default background color for the Grid view (and possibly the Gantt chart as well, don't remember) was the royal blue you see below. I changed the Grid view background to white so the font color could default back to black and minimize the wide…
-
Copy a date in a cell that is formated as a date
Hello everyone, i have a layout where project managers fill in all relevant information into an intake sheet. And then i have created some formulas and automation so that the project sheets would fill themselves upon creation. So far so good. Now I have different date columns in the project sheet that need to be filed in…
-
Email alert whenever the cells within the sheets are edited
I need a workflow, which sends an email alert whenever the cells within the sheets are edited. I have more than 15 columns, and if someone if making any changes to any of the cells after the form is submitted, I need an email alert for such changes. I tried using "when rows are changed" workflow and also "when rows are…
-
Adding a day to Duration for each day a project is On Hold
Hi, I've inherited 90-ish projects that have Dependencies enabled in the End Date column, so this may make my question moot. I'd like to add 1 day to the End Date for each day that a project is On Hold. I've read that I can't add formulas to cells where Dependencies are in place, so I looked at Automation as an option, but…
-
SHARING SHEETS
Hi community, I´ve create a gmail to share a couple of sheets. now I want to cancel this sharing. For that I have to unshare in each sheet. There is a way to unshare global and no sheet by sheet? Thanks in advance
-
multiplication question
Hello, I need to do two things. Multiply the Qty Shipped by the Unit Price for the indented rows. have the total in the outdent. Thank you
-
Duplication
If I filter a column sometimes, I'm getting duplicated entries. Why is that?
-
Copy and Paste issue?
I am just trying to do a simple copy and paste of a row. I highlight a row. select copy. Highlight a row where I would like the new row to be placed above. when I select paste, it place a new row with different information in the cells? anyone else have copy and paste issues?
-
Current User Filter - Help requested!
Hello there! I am brand new to Smartsheet and working with one that has been well developed and is currently being used by our department, about 90 people, without any issues. Recently, I've been asked to set up a report that, when opened, it will filter for the current user. I have tried using some of the rules indicated…
-
set up automation to lock rows, but how do I test them?
I set up an automation to lock rows when the status is done: I can see that the automation is running. Row should be locked. But I can modify them? I need the rows to be locked, so no further edits can be done. Use case: user promotes Jira ticket to "Done" in a smartsheet that is linked to Jira. I now need the row to be…