-
Automatic Workflow Question
I am trying to copy the data from a Business Problem cell to a Project Description cell without impacting/changing previous entries. Is it possible to create a single automation workflow that copies/replicates data from "Business Problem" into "Project Description" in the same worksheet? I tried the column formula route…
-
More Color Options - Make Custom Colors in Conditional Formatting
I would love to have the ability to make custom colors or use color hex codes in the conditional formatting window.
-
Comments for Conditional Formatting
When creating conditional formatting, it would be helpful to have a Comments field where you could add context on what the formatting is indicating, and why it is doing it. This is helpful when you have multiple people that manage the conditional formatting. See the attached photo for a mock-up of this idea.
-
Combining SUMIF( and AND( Formulas
I am attempting to sum a large amount of data into totals based on unit, month, general ledger title, so for example: get a total $ amount for Misc Income in the month of July for X Unit. I'm getting an #UNPARSEABLE error. Are there any clear errors here? I cannot figure it out. =SUMIF({CEAS Budget v Actuals Testing Range…
-
Control Center: Adding new sheet template to the existing projects
Hi all, I have tried to add a new template sheet to the existing project in control center, but it seems not functioning. Is there any ways to do it?
-
countif from 8 different sheets with data criteria
Hello, I have a head scratcher here, I have 8 different sheets that I am trying to pull counts from and only from a certain day. Example: All sheets have a date of outreach, all sheets have a outcome. I want to pull the count of all outcomes marked "Mbr Reached" from 12/02/2025 from all 8 sheets. Question: Is there a…
-
Does the analyze data chart that is added to the dashboard automatically update?
When using the analyze data and then adding the chart to the dashboard, does the data update when new items are added to the smartsheet?
-
Why is Delete Row Greyed out?
I can delete individual rows, but when I select multiple rows its greyed out. Only when I select 1st - 3rd that it is greyed out. 1st - 3rd row, greyed out 1st - 2nd, OK 3rd - 10th, OK 3rd only, OK 1st - 10th, greyed out This happens randomly. Sometimes its not the 3rd that has an issue, and I'll just select another batch.…
-
Moving/migrating existing SmartSheet data to EU
Is it possible to move the previously stored, existing data to the EU, and changing the current Smartsheet region to EU? In other words, can all data be stored within the EU?
-
Need To Figure out a way or a Formula
How do I split the numbers into the same sheet when they are in a same cell like an array which has been brought to that cell using a formula. Eg: i have 182,183,184…. in one cell and I want to split them and create a row for each number on it's own. How do I do that?