I'm trying to track if a site (or Name) created a new daily entry using a Smartsheet form.
I added this formula to the Updated Today column to return a "Yes" answer if the site (or Name) created a new daily entry. This seems…
Formulas and Functions14Amy Arnold
I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are re…
Using Smartsheet224Jakub Gill
Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project.
Most of the reports and dashboards I've tried to crea…
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 w…
We use Resource Views to show capacity loading for each department in our factory. Not sure if this is possible, but it would make sense to me if when tasks allocated to a particular resource were marked 100% complete they would no longer …
Using Smartsheet25Mark Suckling
I need to compare the hours allocated to the hours actually worked, through timesheets.
For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which proj…
Formulas and Functions49soeirorenan
As a Project Manager I need to assign "Non Human" resources to tasks within my Smartsheet project workflow. Some of my project tasks involve using multiple computers for processing. Depending on the size of the project, it can…
Using Smartsheet78Michael Acker
I have been using the proofing feature in our team for internal proofing. I have an issue where as soon as you add a new document version, the previous versions are no longer visible they sit loading. You can still down…
Using Smartsheet69Conner Sherman
Does anyone know how to create a dashboard with Resource Allocation? Dashboard are nice in that I can publish and share them out. I'd like to create a dashboard with the Resource Allocation information that I can then share on an interna…
Using Smartsheet54Carrie B
I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce.
To track the work, I have created one sheet for the legal team to use, covering all…
- import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addre…
API & Developers30adgcz
The previous system admin of our Smartsheet account has left the organisation. How do we change the system admin now ? There is a need to add more resources to our account and we are not able to do the same.
Kindly provide sug…
Using Smartsheet44C. Srinidhi Ragunathan
Working with one of the Smartsheet sprint planning templates and would like to be able to set different working patterns as two parties contributing to the sprint.
i.e. Team 1 work Mon-Friday 8 hour day but Team 2 work everyday except …
Formulas and Functions34Jessica Miller
I want to be able to see a view of all my staff with their associated tasks across all projects. Currently the Resource View does this except it does not label the tasks, it simple shows allocation percentage.
Is there any way to get tho…
Is there a way to "publish" a resource view similar to the way Smartsheet allows us to publish a sheet or a report? Basically I want to get a URL and allow outside users to directly link to my resource views.
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions50KDub618
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me.
Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from …
Formulas and Functions23cthrasher97141
I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and who is on call.
Also, includes …
Formulas and Functions33Chuck Perez
Hello, in Smartsheet's "Project Management Fundamentals" course, specifically in the section on Reporting, there's a great example on how you can compare the original plan (baseline) to actual project dates. The solution illustra…
I've seen posts going back 3 years that address this subject, and it's little mind blowing that a feature as basic and essential as this does not seem to be possible yet. My team works on multiple projects each day, and each project has at…
Using Smartsheet286Jesse L
I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the …
Formulas and Functions95Serena Williams
I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status.
The question is possible edit permissions on cells to avoid that any user coul…
Formulas and Functions25AntonioR
I am trying to have a graph display the count of some things across multiple sheets (~40), as shown in the screenshot.
The only way I could think of for now was to get the data by cell linking and doing some calculations on it …
I have created various resource views by OBS and would like to share them with other users similar to the way it is done with a sheet. How do I share a Resource View?
Archived 2016 Posts99Tom Calderini
As the resource view in resource management is only viewable by licensed users, and is in days, I'm interested to hear from other users how they were able to export data to excel and calculate for a week or month view. I've tried to expor…
We have changed settings everywhere we can find to have our work weeks start on Mondays. This has worked for sheets and reports but we can't find anywhere to change the start day of the week for resource views to Monday instead of the…
Archived 2017 Posts53HeatherDBS
Hello, can an unlicensed user see a list of all tasks assigned to them (across different sheets)? Our resources are frequently unlicensed as they only have to view the tasks, so they can't create reports.
I guess the project managers coul…
We use many (60 or so) individual sheets for each project and a single "dashboard" sheet that aggregates info from all other sheets. We would like to use both the Kanban and Resource view but keep running into this problem: Kanba…
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, s…
Thanks for the duration update. Is there also a way to view resources based on the minutes, hours, or weeks; too.
Archived 2015 Posts44ozgur kaya