-
how to make all (not one by one) complete bar darker than not complete bar on report?
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.
-
VLOOKUP to another sheet - cannot pull these fields into a report, getting #ERROR
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…
-
Combine "AND and "OR" with filtering
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"…
-
Workaround to sort Report rows manually?
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…
-
Can Unlicensed Users Edit Reports
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…
-
Sharing Issues with filters and edits
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…
-
Add Usage Report to Group Admin priviledges
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
-
Edit Start, End, or Duration from Report
I'd like to be able to edit the Start Date, End Date, or Duration of a task from my report. At present I can only edit Start and Duration from a report because End is treated like a formula. This is problematic when I need to adjust both dates because it forces me or another user to do math (accounting for non-working…
-
Cross Sheet Index, Match, and IF
Hi, Thank you for coming to my help, I really hop this question makes sense. Basically, what I want to do is take the closest date of incomplete tasks and put it into another sheet where I can run automation asking someone to update a report. The reason I want to do it this way is because on the report you could be…
-
Showing multiple dates from the same sheet row in a calendar
I have 6 columns in my Smartsheet that are date columns, two of which are start and end dates. I have got the start and end dates to appear in a calendar report, but the other ones (individual dates, not date ranges) do not show up. I cannot have them as children rows. I have tried applying conditional formatting to the…
