-
Working Days and Holidays for different Resources
Current project settings allow to set-up working/non-working days and length of day in hours globally per project (see screenshot) We have teams from different continents and countries (US, India, China, Germany etc) working on the same project. It would be good to have an ability to set-up working/non-working days and…
-
6 Teams- 1 Dashboard Help
I'm trying to find the best/easiest way to display data from a Sheet Summary Report into a visual Dashboard. We have 6 different project teams, each with multiple tasks or projects with criteria we need to report on as a whole. I've summarized each sheet to give me the specific metrics I need, but now I need to get that…
-
Card View in Reports
Is it possible to have Card View in reports? It would be great to be able to see a card view board for multiple sheets at once.
-
Publish sheet in multiple views?
I'd like to show a sheet in the dashboard in both: 1. Grid view 2. Calendar view WHen I publish the link to put on the dashboard, it only one or the other. Please tell me there's a way to publish in multiple formats!
-
Notifications, Report or Dashboard
i am new to smartsheet and using it to keep track of inventory across multiple locations which have different contacts by location. What is the best method to send a scheduled listing of assigned assets to each contact owner. Would like them to only see their assets and be able to change the location if they no longer have…
-
Status Symbols
We don't want project teams to use yellow ball. Is it possible to have only Red and Green Balls as Drop Down Options to select for Status?
-
Creating Report without Sharing Sheet - I need help!
I am trying to find a solution...I have tasks related to confidential legal matters that are in a smartsheet. As I am breaking those matters down into tasks within the smartsheet there are some tasks that are not confidential and I need my administrative assistant to complete them without being privy to the broader issue…
-
How to create formula to count upcoming tasks in the next 90 days?
I want to see how many tasks each project I have are upcoming in the next 90 days. I can run a report to see this information, but I want to be able to display it in an easy to read chart with each project showing how many tasks they have. See attached example. I built the attached chart by running the report with the…
-
Cross Sheet Logic/Data Sync
Hi, I have a signup sheet that I am trying to get to update from another sheet. I essentially want to take "Unique Code from cell X on Sheet A and look for it anywhere in Column "Code" on Sheet B. Once it finds it on Sheet B, I want it to return the data contents from another column in the corresponding row to Sheet A. For…
-
Report based on specific text in a cell
Hello, I have a data sheet used for a call log for project issues. I'd like to be able to run a report that displays all calls for a specific serial number based on which serial number is entered into a cell, a variable search value. Ideally, I would have a dashboard with a web content widget that would be looking at a…