-
Roll up Fail
I have a test scenario as a parent and a sub-task as a child. So let's say, I have 11 sub tasks under the parent, if one of those 11 children has fail in its status, the parent will say fail. If all say pass, then the parent will say pass. I couldn't get the formula to work what I wanted it to do.
-
Add function to retrieve values from cell for a multi-select column
Like the COUNTM which gives the count of values in a multi-select cell, it would be great if there is any function or combination of functions that can provide an array/list of values from a cell so that any particular value can be compared/matched/processed.
-
How to Automate workflow to create a summary report to diff between two excel sheets on weekly basis
Using SmartSheet, I want to be able to import excel sheet from sharepoint on weekly bases lets say "week 09" excel sheet name is [TC Roadmap 25ww09 VTS] Then I need to add to end additional +5 columns, these column includes formula(s) which I use to massage data coming from original data to create reports After a week ,…
-
Auto sequence based on date
I am looking for a formula to sequence or auto number rows based on a date and order the sequence number simply 1 through infinity. I would like this formula to work even when I add or remove rows or change the dates. I also can't have any duplicate numbers in the Rankeq formula and has a tie breaker column.
-
Pull latest formula help - index/collect/max
Trying to use Max(Collect) but keep getting #INVALID REFERENCE# =MAX(COLLECT({Sheet A Date}, {Sheet A- Date column}, {Sheet A- Equipment Name column}, [Equipment Name]@row)) But having trouble applying these to my scenario. How do I update these for my scenario? Sheet "Device Master" has Device Barcode field (and lots of…
-
Show what's next on primary row
Primary row 1 Status Up next:subtask 2 Subtask 1 Complete Subtak 2 Subtask 3 Primary row 2 Up Next: Subtask 1 Subtask 1 Subtak 2 Subtask 3 Primary row 3 Up Next: Subtask 3 Subtask 1 Complete Subtak 2 Complete Subtask 3 Is it possible to have a layout like this. So once everything is collapsed it will show what is up next…
-
Vlookup - copy a date to another sheet
Hey, I would like to use a vlookup to copy a due date to another sheet. The vlookup works in other cases, just with the date it doesn't and I get #INVALID COLUMN VALUE as a result. I know it has to do with the date itself but I am unable to figure this out myself :-) - can someone help? The formula:…
-
Add an ISBLANK Function?
All, I have the following forumula: =IFERROR(INDEX(COLLECT({INDEX Rebate}, {MATCH Prod Name}, [Product Name]@row, {Report}, @cell = 1), 1), "No Rebate") I want to add an additional check, so that if the matched cell in the {INDEX Rebate} reference range is blank, the output of the forumla is also "No Rebate". All my…
-
AVGW Formula for Multiple Cells in One Column
I am trying to apply weights to multiple cells in a "% Completed" column. My current formula just averages out the values for the selected cells: =AVG([% Complete]3, [% Complete]5, [% Complete]7, [% Complete]9, [% Complete]11, [% Complete]53) I'd like to apply weights of 10% to row 3, 5, 7, 9, and 53 with a weight of 50%…
-
Count or Sum formula
I want to sum the columns that contain 1 and have tried a SUMIF and COUNTIF Formula, as well as using the AI formula generator within the sheet - nothing is working. As you will see from the screen shot below I would be expecting this column to return a value of 7 but, it just returns 0. I know it's going to be something…