Hi, I am trying to create a smartsheet to track the quality of a constructed panel. The constructed panel needs to be checked at certain points by different team members. The data needs to be stored t…
For example, I am using cell linking to pull in two different large pieces of data from two separate sheets. What I'm trying to resolve is how to flag column 3 date if it does not match column 2 date.…
Use case. 4 sheets Intake Sheet, Prioritization sheet, Resource sheet & Overall Status Sheet When a project is requested it is automatically added to the "Intake" sheet through the form. Status field …
Hello, I've had a colleague come to me with a query about how best to link 2 sheets. Her enquiry includes a handy diagram: I'm wondering if cell linking would be best bet here? I realise this would ob…
My Smartsheet application is going on six years old now and was in need of a rewrite after years of incremental improvements that used newly available capabilities in Smartsheet and as the needs of my…
Hi all! I'm currently using the following formula (with references) to count the amount of items that fit a certain criteria (91-180 days, 181-270 days, and >270 days): =COUNTIFS({Age Grouping}, "desi…
Here is my scenario: I am redesigning some of my template sets and dashboards but leaving the originals up and running at the same time. I created a sandbox environment (workspace) to do this in. Some…
We use a standard project plan (~100 tasks/steps) as a template for our team, and it gets copied for each new project. There are ~6 tasks on the project plan that drive Jira task ticket creation. Inst…
Hello All, I am wondering if there is a way to automate this process. I am trying to get a count of each line item status type at the end of each day. Currently, I am updating a master sheet that has …
