-
Counting Total Number Correct of RYG Balls per person
Hi Can anyone help me with my a formula that will allow you to count the "Green RYG balls" which means completed for our purposes. I am trying to count the number of completed "Green" RYG balls, per person in order to use on the dashboard I am creating. I trying to display how many tasks has "John Doe" completed and I only…
-
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
-
Deleting a Report Item also deletes it in the Sheet?
I came across an interesting interaction today while editing a report. When I went to delete an item off of the report, the item itself also disappeared from the sheet that it was associated with. Is there any way I can retrieve that information and have it back on the sheet but not the report?
-
Possible to create Gantt Chart in duration of "hours" for single-day projects?
Hi, I created a project smartsheet with gantt dependencies in duration of "hours" for an important project that lasts one day. I was wondering if there is a way to create a gantt chart that only displays one day but shows durations of "hours" on the x-axis instead? (The current gantt chart I see only displays 30 days…
-
Sending Attachments
I want to send/share a row with someone and I want them to be able to see the images in the attachments without having to open them. For instance, I need to send a General Contractor a Weekly Report of work completed. There are attached images on a row that need to be sent to him. I could share the row, but it would not…
-
Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
-
How to use a widget to be able to add a modification date in sights?
I would like to know how and I add a widget to my sight page that will automatically update whenever there are any changes or modification done to the associated sheets it is linked to. I see something similar on one of the examples on the sights help pages and videos but it doesn't exactly go into details on how it was…
-
Workflow Automation
I am sure this scenario has been discussed elsewhere. However, I was not able to find it. I am trying to create a workflow using Web Forms. When an employee fills out a request in a Web Form I would like to automatically send that Web Form (with an additional dropdown field 'Yes'/'No') to the employee's supervisor for…
-
Meeting agendas
Hi All, I am wondering if some of you have ideas regarding setting up agendas for meetings. We have various sheets for example: Sales, Finance, Tasks, Schedules, etc. I want to design agendas for each weekly meeting. How can I get only specific items pulled through from all the sheets for what is relevant for a certain…
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…