-
Stack multiple saved filters
It would be helpful to be able to "stack" multiple saved filters, so that a user could apply multiple, orthogonal criteria at once without having to create a cross product of defined filters. For example, if records can be either "current" or "past" and either "material" or "immaterial," a user might want to search for…
-
Allow basic copy/paste in table view
Allow pasting a url into a cell in table view without throwing an error that I have to google to find the solution is switching to grid view, pasting, saving, switching back to table view. https://community.smartsheet.com/discussion/141068/issues-with-copying-in-the-windows-app-table-view?tab=all
-
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.…