-
Change Value in Symbol Column Based on Value of Other Column
Hello everyone! I have a Status column (Symbol type), where users can choose manually the desired status. I also have a Completed% column (Text/Number type), where a percentage is entered manually. I would like to change the value of the Status column to "Blue" when Completed% is "100%", but keep as is in all other…
-
Is there an ability to set re-occuring dates in the same row? Calendar/Gantt view
I have several rows on a sheet that have a set date/time each month (i.e. first Tuesday of each month). While i have the durations set for gantt view, I do not see an easy way to add additional dates for the same tracked item? Would I just need to have additional start and end date columns added for each month with a…
-
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.
-
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?
-
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?