This discussion has been merged.
Does anyone know how to make all (not one by one) of the percent complete portion of the bar so it's darker than the % not complete bar? It's really confusing the way it pops up. I've tried to change several conditional formatting settings and no dice.
This is a request to automate updating the report columns when the underlying sheet's column name is changed. After the new Smartsheet release that connects the old column names with the new ones, there are more clicks required to update the report's column names. The extra step is having to disconnect the old name from…
I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VLOOKUP columns. I'm seeing an issue where the report can only successfully pull data in sometimes. Sometimes I open the…
I did not see this topic covered: Is there a way to combine logical "AND" and "OR" when creating a filter? The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR) Here is why I am asking: I want to filter a buzzword that some people put in the "Comments" field and others put in the "Suggestions"…
I wanted to create an ability in my Workapp or Dashboard that would pass the filter criteria to a Report and show only the filtered rows. Is that possible? Is there a workaround?
Anyone have a workaround solution to sort Report rows manually? For example, we need to put priority items at the top - but that priority is manually adjusted (not logical). Using a 'Priority' column to sort by doesn't work, because they want to move around and see how it's adjusted without having to save and refresh the…
According to the [docs](https://help.smartsheet.com/learning-track/free-users#:~:text=Free%20users%20have%20the%20ability,own%20items%20without%20a%20license.) "Free users have the ability to view and/or edit the items they have been shared to". I would assume items would include reports, but, as unlicensed user, I can…
I was asked to help with some Smartsheet items (grid, dashboard, and report). I was given Editor (can share with others) for all three documents and I am on an Enterprise licensed account. With the Grid sheet: It also will not allow me to: add columns edit columns sort rows delete columns add column descriptions etc. It…
Why do I need to go through the system admin, who is very overwhelmed with more important issues when I want to see who on my team is using their Smartsheet license or not
