I am trying to resolve a #DIVIDE BY ZERO error. I've seen the other resolutions, but they are not working for me. Here is the formula that I am using: =ROUNDUP(([Anchor Install Hours]@row / {Amazon - …
Hi there folks. I'm fairly new, so this may be a fairly basic question. I'm using Smartsheet for project management, I'm in the planning and intake team. When we intake a new request and it's approved…
We are creating new courses and content for our LMS and we want to use a project sheet to track all the tasks associated with developing the course and its respective content from beginning to end. We…
Hello, I can't seem to figure out how to trigger a new Workflow on an existing data set. I created a Move Row Workflow that is triggered by a change in my Status column and where there is a date prese…
I have a team that is updating date estimates in a large sheet. I'm looking to create a project sheet from that matrix/range. I'd like generate the sheet with links at the same time so that when the t…
Objective: Have dashboard that reflects defect status and who is assigned to it, if blank then "Not Assigned" Example 1 Jake has three defects assigned to him. 2 = "Intake" 1 = "Vendor In Process" Exa…
Hello, I am wondering if you can help. I currently use Smartsheet for project planning. I would like to build an automatic percentage complete formula. This formula should work off a linear progressio…
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to …
I am creating a project status dashboard that will encompass all of our projects. It's simple enough to link each line to a project but the thing I want to be able to grab is the baseline start and en…
