-
Hello, i am trying to create an If-Then-Else formula to calculate Qty of Doors we can manufacture?
Based on 'Qty of Doors' times by 3 Types (N/A = 1, D = 1.25 and F = 1.5), divided by the 'Team Size', divided by 'Throughput Target'.
-
Need to add the year to this formula?
=COUNTIFS([Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = 5) I would like to count these months by the year? How do I add the year to this string? Thanks
-
Help with If / Match / Vlookup Formula
Hello All, I was away from Smartsheet for a bit but it's great to be back! We have a lessons learned sheet that needs to pull information from either a sheet of open projects or a sheet of closed projects using a VLOOKUP. I'm using this formula: =IF(MATCH([Project Name]@row, {Closed Projects Range 2}, 0) > 0,…
-
How to remove decimals from a percentage formula with text before it?
Hi, I currently have the below formula: ="Completion: " + [Product Data]@row / [Units Sold]@row * 100 + "%" The cell then shows "Completed: 4.05405%". However, I'd rather this be "4.05%". Please can someone advise how I can fix this? Fairly new to Smartsheets so I'm still learning! I've tried to click the 3 dots and remove…
-
Sort by two dates, then rank based on ascending sort
Hello all, I have a sheet with two key column dates. I want to sort by Date1, then sort by Date2 and if a row has both dates, I want to assign it a number (rank it) based on the order it appears in the sort. I've tried: =IF([Date 1]@row <> "", IF([Date 2] <> "", RANKEQ([Date 2], [Date 1]:[Date 1]))) but it seems that the…
-
Automatic workflows
Hi, we have an approval workflow in place however we were receiving TWO emails at the same time (Request for Update and Request for Approval). We have since put a rule in to stop this however we are now not getting notified for approval once the request for update has been submitted. How do we trigger this? Thank you
-
RYGB health changes on date and status
=IF(ISBLANK([End Date]@row), "", IF(Status@row = "Complete", "Blue", IF(NETWORKDAYS(TODAY(), [End Date]@row) < 0, "Red", IF(NETWORKDAYS(TODAY(), [Start Date]@row) <= 6, IF(Status@row = "Not Started", "Yellow", "Green"))))) Goal: Health RYGB balls. -red, end date past due in any status -yellow, start date <=6days of today,…
-
Metric Widget pulling data from a report
My objective is to create a dashboard where user can see the count of his/her tasks by status: On Track (green), Concern (yellow), At Risk (Red), and Completed (Gray). Each status is a presented as a metric widget. When user clicks a certain metric widget (i.e. red - tasks at risk), a DynamicView window opens and pulls up…
-
Simple Date Function
=[Actual Closure Date]@row - [Deviation Opened]@row For fields that don't have a date, currently showing up as #Invalid Operation. Would like it to display blank instead. Thank you.
-
Average ifs formula
I have tried using the AVG(Collect formula and can't get it to do what I need. Anyone have any ideas on how to get the average of the cells in column1 if the matching cell in column 2 is ="Inbound" and the matching cell in Column 3 is equal to either "Developing", "Contributing", or "Experienced"