I think this formula should be easy but I am terrible with formulas. There are 4 columns, when there is a date = 25%, if there is no date =0% and the final column that will show total % complete for t…
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 tot…
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, howeve…
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…
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 …
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 checkli…
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 every…
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…
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 …
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 an…
