-
Formulas not always autofilling
I have a SmartSheet that I add new rows to at the bottom of the sheet daily. All the rows above the newly added rows have formulas in them. Some days it autofills the formulas into the new rows. Other days it takes several minutes before it autofills them. Most of the time, it does not autofill at all and I have to…
-
Last value from INDEX MATCH
I am a smartsheets newbie, but have good experience with Excel and have been trying some things for an inventory management tool that I am creating. Typically in excel I use the following formula to pick the last value from INDEX MATCH and it works well to give me the last matching value in the range of C3 to C12 from the…
-
Sumif returning 0
I am looking up sales and wages hours for 7 different locations and the sales all work perfect for all 7 locations but the wages hours are only correct for 3 and on all the others it is brining back 0 instead of the correct amount for all the weeks. I have deleted and checked all formula's to make sure they are correct but…
-
Difference in cell value between 2 rows based on multiple criteria
Dear Smartsheet, I have a long list of parts based on columns A & B (part & position) with different install dates and hours (column D which is cumulative). I would like to have a colum E (hours on part), which is a difference in operating hours (column D) from date in row to next date when part was installed (ie E7=D8-D7)…
-
Pull Data from Column 3 of Master Sheet if Values of 2 Columns in Sub-Sheet match with Master Sheet
Hi, I have a master sheet where I have different columns. I want to pull data from another column of master sheet to different sub-sheet based on following criteria: Column 1 of Master Sheet matches with Column 1 of Sub-Sheet Column 2 of Master Sheet matches with Column 2 of Sub-Sheet When criteria is met, the Return Value…
-
How to do calculation rather than just COUNTIFS or SUMIFS
Hi, I have a table like a inventory with all goods with unit price. Such as: A1 A 100 $5.00 B1 B 200 $10.00 A2 A 150 $7.00 B2 B 50 $12.00 C1 C 80 $20.00 If I want to count how many "A" I have now, I can use COUNTIF(A). My challenge is, I need to calculate the total price of all goods under category A, like:…
-
Formula Question/ Help Needed
I currently have the following Formula updating a STATUS (Not Started, Complete, IN Progress) based on % Completed. Works flawlessly =IF([% Complete]272 = 1, "Complete", IF([% Complete]272 >= 0.01, "In Progress", IF([% Complete]272 = 0, "Not Started")) I want to take this to another level. As I have another column "Health"…
-
Average Formula for Child Rows on different column
Great Afternoon ! I am having trouble to create a simple average formula for child rows. Please see attached the picture. On the red field I would like to get the average of the child rows, from the column named TOTAL OWE-LIVE/INV. AMOUNT. In other words, that cell should show $11,266.88. Your help is greatly appreciated!…
-
@ row used to determine month and year but summary formula is now invalid
Hi All, I have successfully created an @row formula to automatically populate in a cell in my sheet which is super awesome. For this example I am showing the Month Reported but I also used a similar formula for Year Reported. But now that I have that completed, my summary formula that previously worked no longer does. How…
-
Formula for adding months onto a date
Hi! Can someone please help me with a formula to auto calculate the 'Expected Finish' by adding the 'Duration' to 'Actual / Expected Start Date'? Thanks so much! This formula is getting an 'invalid data type' error: =IF((MONTH([Actual / Expected Start Date]@row) + VALUE(LEFT(Duration@row, FIND(" ", Duration@row) - 1))) >…