-
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…
-
2 tracker sheets, merged into one resource sheet?
Hello, I have two sheets, one is a fabrication tracker that tracks different jobs in our machine shop, and we have a design tracker that tracks current designs being worked on. I would like to combine both trackers into one resource tracking sheet that shows [Name] [Job #/ Design #"] [Role] [% Occupied]. Image below is…
-
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…