I have linked 2 cells from another Smartsheet that are child tasks to my project plan. When trying to average the linked cells in the parent task, I am getting a divide by zero error. The linked cells…
I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows? I also would like to make a formula for a metric sheet that automatically…
Hello, new to Smartsheet so might not use the correct language, but hopefully someone understands what I need! In my company we host CPD sessions where suppliers will come in for an hour over lunch an…
Hello All, I have a form collecting construction progress updates. When a from is submitted, I would like the "Construction Report" on a separate sheet to have a completed date (equal to submission da…
Below is a screenshot of the target sheet cell (Created on : etc) I want to update automatically when the source sheet is changed We currently have a cell link, but this is not updating without removi…
Using Control Center, I am adding an "optional" sheet from the blueprint templates to some existing projects. While Control Center is then linking the identified "Blueprint Summary" fields from the ne…
Does anyone know if there's automation or a Formula where I can pull the Sheet Title into? For example, I want to create a "Project Name" column in a template that will bring the Sheet Title down to t…
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific …