-
Not sure what formula to use to get 1 description name with the average MM per Piece
I have a sheet with a column named Description and another column named MM per Piece. There are multiple items in the Description column and I need to obtain the average MM per Piece based on the entries for each item. Any assistance is appreciated.
-
Pivot table showing date
Hi All, We have a bunch of project schedules that list milestones in the primary column (IE Kickoff, First Milestone X, Construction complete, etc). So each milestone has it's own row. I would like to make a report where the rows are each project (or sheet name) and the columns are the major milestones. The value in the…
-
Copying data to a second sheet
Hi there. Ok, so I have a master sheet that is housing our full repository of FAQs and then I have another sheet that I currently have Copy Automation (from the master) that is pulling any adds/changes when the Approved column is checked. However, I'm running into an issue that now that automation is pulling duplicate…
-
Can't Save Field Logic Updates in Dynamic View
Hi all, I've seen a few similar posts regarding this, but they were from a few years back so not sure if anything has changed. I want to add Field Logic to a field in our form. It asks the user to select a Category and to deter using Issues/Miscellaneous, I have added a dropdown column in the sheet for the user to confirm…
-
RFQ and Invoice
Hi Team, I am trying to find a template to create/form a RFQ for a customer and then turn that into an invoice. So for clarity - customer ask for a quote to build a product that has multiple steps to complete. for example: Purchase metal, cut metal, shape and form metal, weld metal, pain and ship. Steps and processes might…
-
Parent and Children column status updated according to the Children
Hello again, I added this formula for my parent column to be updated once things change in the Children: =IF(COUNTIFS(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIFS(CHILDREN(), "In Progress") = COUNT(CHILDREN()), "In Progress", IF(COUNTIFS(CHILDREN(), "On Hold") = COUNT(CHILDREN()), "On Hold",…
-
Creating Formulas for Status, and Task Health to send Email Notifications
Hello, Everyone I need help with my syntax on some formulas and sending email notifications. • Status ○ If the %Complete is 0%, Status = Not Started ○ If the %Complete is between 1%-99%, Status = In Progress ○ If the %Complete is 100% = Complete § Questions: What if the task is no longer needed? In MS Project, we would…
-
Stuck on Multi-criteria countif function
Hello, I am trying to find active pilots at risk by using countif to find the following in a range: Planning Pilot Execution Pilot Summary Approval to Launch That have a status of red or yellow Is there anyone great at these who can help? This is what I have so far: =COUNTIFS(Sheet - Pilot and Readiness Pipeline - Pilot1,…
-
Production Downtime Tracking - Crossing the Dateline
Thanks for taking the time to read this post. I am attempting to restructure my companies end-of-shift reporting system with smartsheet to facilitate better automated data processing. An issue i am currently dealing with is how to calculate the impact or "Yield" in minutes of line downtime as we cross from one day to…
-
Iterative calculation for circular formula
Is there anyway to do iterative calculations in Smartsheet like Excel has for circular formulas? Trying do to do a budget table like this Which is made up of a circular formula that only works with iterative calc turn on in Excel.
