-
Calculate the right average for the columns
I need the average collect to calculate the right total % complete for the columns Each column that has a date is = 100% If there is no date is = 0% but the formula still counts the 0% to give the total % average complete on "Quote % Complete" column. If there is "N/A" either in "1st Circuit Quote Status or 2nd Circuit…
-
Automation to "Change Cell Value" to embed a formula into the cell
Trying to set an automation to "Change Cell Value" 2 columns involved: "BARCODE" and "PACKAGE UID/LOT #" If "PACKAGE UID/LOT #" is not blank, then I don't want to override the data in the cell, however, in the absence of data in that cell ("PACKAGE UID/LOT #" is blank), then duplicate the data from "BARCODE" into "PACKAGE…
-
Metrics sheet - Want to use formula to pull in date when column type is "text/number"
Hello, and thanks so much for any support with functionality or a work around. I am creating a summary page for the system I am building. I would like the summary metrics to form a grid like table for visualizing sections of data. First column is the title and second column is the data. The column type for pulling in the…
-
Linked Cell Not Working
Hello! We are linking cells from a project plan to a master sheet. Every other cell in the row linked just fine, except for the last one. It says that it is linked, but no information is being pulled into the cell. The cells in the project sheet are filled out and linked out to the master sheet: These are the corresponding…
-
Roll over Monthly checklist
I am looking to create a month-end checklist which has list of activities and due dates and tracks the completion status driven by user inputs. What is the best way to a) archive the completed checklist and b) roll over the checklist month over month. The fields are consistent month-over-month with 80% pre-populated in the…
-
Is there a way to create a 'collapse section' on a Dashboard?
I'd like to truncate the Dashboard view for my users so that they can select what they want to see by Section Content (eg Project Progress, Project Resource Links, News/Updates etc.), instead of everything being available as a huge data dump a mile long. Is there a functionality to expand/collapse sections on dashboards…
-
Is there a way to use a checkbox (or formula) to bypass a required form field or turn it off?
We have a contact information form that will be distributed quarterly so the respondents can provide contact info changes and updates within their organization to ensure that we always have up-to-date information. Most of the fields are required however, in the event that the respondent has no new changes or updates to…
-
Updating an Attachment without Re-upload?
Is it possible to update an attached Excel file in Smartsheet and have the changes be saved without re-uploading? Or, can an attached file be linked to automatically update when the source is changed (whole sheet, not just linked cells)? Overview: We have an overall project tracker sheet in Smartsheet. One of the tasks is…
-
Count "Red" symbols in Sheet Summary
Hi all, New to Smartsheet and wondering how I get my sheet summary to count the number of "Red" symbols for status reporting. Understand that COUNTIF won't count symbols from what I have read. Does anyone have a way around this? Thanks in advance.
-
Changing the "Contact" function (Global Variable Please?)
Salutations, Presently, I am attempting to generate a productivity report regarding employee projects and workflows. I have utilized the Contact feature, as I'm only tracking/assigning tasks for Management level. No other users will use this or see it. However, we are unable to presently store sheet-specific data, as…
