-
How to set up recurring task schedule for Payroll team?
Hello all! My company's Payroll team is seeking a task management solution to help them track recurring to-do's related to payroll processing. We are on a 24 period pay cycle (15th and last) and there are some tasks that need to happen every cycle, some that happen periodically or annually, as well as one-offs. They'd like…
-
Merged: Allow the Report in Gannt View on Dashboard to display complete bar darker than not complet…
This discussion has been merged.
-
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…
-
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…