-
#DIVIDE BY ZERO Error - other resolutions not working
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 - Brownfield - Priority Sites - Set Range 2} / [# Anchor Technicians]@row), 0) I tried the IFERROR(ROUNDUP resolution and that…
-
Auto create multiple sheets for one project
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, I need to then create a project from that request record. When I create this new project do I need to manually create a…
-
Expand/Collapse rows
Expand / Collapse all is not an option on my primary nor any of my parent rows. Why?
-
Is it possible to develop a task list from multiple source sheets through automation?
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 have a handful of different "Learning Object" types that each have their own repeated tasks or activities to develop and…
-
Triggering a Workflow on existing data
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 present in another column (two conditions). I am having to change the Status from Completed, save it, then change it back to get…
-
How to best pull data from a matrixed sheet of dates and milestones into a project sheet?
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 team revises dates in their sheet the project sheet updates as well. I don't want to have to manually create Column A entries…
-
How to count the times a person is assigned to a defect status
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" Example 2 Eric has 5 assigned to him 1 = "Resolved"; 3 = "Ready for Retest"; 1 = "In Process"; For any defects not assigned,…
-
Automatic Linear Percentage Complete Formula
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 progression line from Actual Start Date to Baseline Finish Date and the duration. So an example of a task would be: Actual Start: Now…
-
Smartsheet count function
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 count that line?
-
Is there a way to pull the baseline start & end dates from a project sheet?
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 end dates from the project. Short of scanning a column and finding the lowest and highest numbers, is there a way to access…
