-
Seems basic, but I'm having a hard time calculating the expected progress vs actual progress
Hi Everyone, I'm new to smartsheet and I'm having a hard time figuring out how to take the planned progress versus the actual progress in roll-up form. For example, for planned progress (percentage), I have the following formula roll-up that I found in the community that looks to be actual: =IF([Planned Start Date]@row >…
-
Error Fix
I'm Trying the add a Column Formula and want to add an Iferror but I can't Figure it out. Currently have: =(([Total Cost]@row + Crate@row + Tax@row + Freight@row) / Quantity@row) I don't want to see #DIVIDE BY ZERO Thank you for your help
-
Formula to Average Performance Score for Various Service Categories
I am trying to create a formula that averages the performance score of various service categories. For example, whenever the service category (drop down box) has "civil engineer" selected, I want a running formula that averages all the civil engineer ratings. I have tried using the =averageif() formula, but I continue to…
-
Vlookup for a single column with more than 11 Sheets
This discussion was created from comments split from: [UPDATED] Community Reward Program 🏆.
-
Date Format Formula
My org has a sheet that logs work orders by date received. The date format is 01-03-2022 08:47:13 AM. I have formulas on another sheet to count the total number of work orders per quarter. =COUNTIFS({WO Log Range 2}, AND(@cell >= DATE(2023, 1, 1), @cell <= DATE(2023, 3, 31))) The formulas aren't working. I think it's…
-
How Do I link the Status Column to the % Complete Column?
I am looking for a formula that will allow me to update the Status Column (not Schedule Health) to update based on the % Complete (or vice-versa). Example: If the % Complete is updated to 100% the Status should auto-update to Complete. If the % Complete is anything between greater than 0% and less than 100% the status…
-
IF THEN ELSE Help
I've tried to make this work but can't in SmartSheets but can in Excel. I would like to copy the greater value of two cells into adjacent cell using (IF, THEN, ELSE) function. It does work in Excel with the following; Cell H14: IF(D14>=F14, D14,F14) I posted this help else before I understood better how to ask questions.…
-
INDEX/MATCH formula assistance needed
Hello. I'm using the following formula to match resources with their resource manager (=INDEX({Resource Manager2}, MATCH([Assigned To]@row, {Resource2}, 0), 1) ) and it works great for a 1:1 scenario. However, I have a many to one, or many to many scenario and I need help modifying this formula to accommodate both of them.…
-
Formula Help
Hello, I recently used this =SUMIFS formula and now that I have changed some VLOOKUPS the formula gives me a #NO MATCH error. SUMIFS([Request Total]:[Request Total], [Employee ID]:[Employee ID], [Employee ID]@row, Date:Date, <=Date@row, Date:Date, >=DATE(2022, 7, 1), [Department Approval]:[Department Approval], "Approved")…
-
Cross-sheet Formula Limitations and Possible Work Arounds
First, what does the term "distinct cross-sheet reference" mean? I've just run into a message that I've exceeded the 100 distinct cross-sheet references and am looking for a possible workaround. Background: We have three sheets with various information about our employees. Basically, one sheet is the Employee Master List.…
