-
Average of a drop downbox item
Hello, I am currently working on a project that involves a Dropdown box that has 3 options, Not Started, In-progress and Completed. However, I would like to get the average status of the project, and the the formula I am currently using doesn't seem to be working properly so I was wondering if I could have some help. This…
-
Looking for some guidance: need recommendation on the best template to use with client to track feed
Hi to all and thanks for considering my request. We're somewhat new to SS, have looked at all templates without finding a product evaluation feedback form that would allow users to share issues, insight, feature requests and help requests for a 30 day product evaluation period. I'm not expecting to find the EXACT template,…
-
List of Automated Reports
How can I list my automated reports? I've got a number of automated emails with report attachments going out to a wide audience on a regular basis. I want to tidy them up and reduce noise and redundancy. I'd prefer to avoid scanning through all of our reports manually if there's a better option. Thanks for any advice, Josh
-
Summary Cells & Adding Rows
If I understand Smartsheets correctly, all formulas must reside within the sheet where the data exists meaning, if I want to display a metric or a total on a Sights Dashboard or Report respectively, I cannot. So, what do you recommend I do to create summary cells on a sheet where rows will be continuously added?
-
Help with creating a dashboard
I'm new to smartsheets. I've set up a work tracking sheet with a number of status conditions. I'd like to create a view for folks to use - maybe a dashboard? Let them check the status of their requests, show a pie chart representing the total number of requests in each status, average time to completion, etc. Any ideas…
-
Report showing resources and assigned projects
I'm looking for help developing a report. I've got multiple projects and multiple resources working on those projects, and I'd like a simple grid - resources in a column, project names across the top, and an x indicating which project each resource is working on (or something like that). This view will give a snapshot of…
-
Detecting Cell Changes, Modifying other cells on update.
Hey guys. So, I'm curious if there's a way to do something. I want to detect certain changes in a cell, and modify another cell based on the date those changes occur. The goal here is to automate the entry of dates of completion. I've thought about entering the following formula in a date cell: =IF([% Complete]2024 = 1,…
-
Report not showing information from all sheets
Hello, I'm attempting to create a report from multiple sheets. The majority of the sheets are set up in the same format, but one has different information. It appears to be pulling the information for the similar formatted sheets, but not the one different sheet. The primary column information for all of the sheets matches…
-
Rolling Dates in a report
Hello. I have a project sheet to track individual projects. Each project is a separate row in the sheet, with a Start date, a Duration and a calculated Finish date. New projects (new rows) are added to the sheet via a form that that can be used by anyone from our web page. When the for form is submitted with a new project,…
-
Production/task management with sales order taking
We are a small custom sign manufacturing company. Our clients can order any number of products at a time ranging from small items to custom furniture. All have a similar start to finish process with some customization along the way. We would like sales reps to be able to enter orders directly into a page with details on…