-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
-
User Friendly Search
We would like to allow conference attendees to check themselves in using tablets at the conference center. I know there is a "find in sheet" magnifying glass in table view, but it is not super obvious, especially for non-Smartsheet users. Is there a better way for them to easily find their row among all the attendees so…
-
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…
-
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?