-
Formula that will track the total number of jobs on the sheet at the end of each month
Hello, I am looking to create a formula that will track the total number of jobs (populated rows) in the sheet at the end of each month. The data outputted based on the formula will be displayed on a line graph widget in order to track the progress of the company by each month. For example, if there are 115 lines at the…
-
Resource Management Schedule view by department
Hello, Is it possible to get projects grouped by department like in the attached picture? I don't see where there's an option to sort by department, and from my understanding using tags for projects (i.e. creating a "Marketing Department" tag and attaching to appropriate projects) doesn't consolidate them as nicely. For…
-
Amendment to Contractor/Project Editor Permissions within Resource Management
One of the limitations of the Contractor security permissions within Smartsheet is that a user is unable to "split" their allocation as they do not have access to Schedule view. However, to give them access they would need to be upgraded to Project Editor, but this then means they have full visibility of capacity for…
-
Merged: Favorite bar organization
This discussion has been merged.
-
Track Form Submissions By Date
My organization has several forms set up that are utilized quite a bit. I'd like to track how many forms are submitted on a given day, week, month, quarter. I have tried countifs, and a whole bunch of other formulas. I also made a report but I am unable to pull report metrics into a dashboard so that it can visualized…
-
Multiple assigned to with different workload
Hello, I want to assign different workloads to people who are members of projects, but I am unable to figure out how to do that. For example I would like to set up: Project A has 2 members: Member A with 5% capacity Member B with 15% capacity thanks in advance
-
Workload in Smartsheet
For clarification: What are the license requirements to see the Workload heatmap in a Smartsheet project plan ? I was under the impression that a project manager would NOT need an RM license to see this ?
-
Empowering users with Smartsheet Forms or Apps
Hi community. I hope all are well. I have an idea which can be useful to many using Smartsheet. While this idea and use are for a particular use case, it can have vast potential and versatility for several applications. Problem: Our current Smartsheet forms system lacks user control and transparency, leading to…
-
Business plan. Limitations on the number of dashboard widgets. No access to Team workload tracking
Good afternoon. I am a license holder by invitation to the work team of our company under the Business tariff. Why the license holder has a restriction on the number of widgets on the motherboard, if the business plan does not have these restrictions, and the restrictive message says “upgrade to Business or Corporate”?.…
-
Office Status Calendar
My company has been researching on how to track the status of the employees working in office. We created a sheet where each day of the week, not including weekends, is a dropdown column with the choices of: • IN OFFICE • REMOTE • OUT OF OFFICE We also use conditional formatting for each column where if it selection is IN…