-
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…
-
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…
-
Merged: Need report options to export Users by User Group
This discussion has been merged.
-
Selected data cannot be charted. Please select a new range error
Hello- I have charts on a few dashboards all set up the same, and they all stopped working. I tried creating a copy of the reports used in the charts but that doesn't help. Below is what one of the charts used to look like. It's a stacked bar graph showing the balance for the last available month and the $ in Foundation…