-
Need help ignoring blank date columns to use MIN formula
I am trying to first convert a text string into a date to use in a MIN formula. Some of my cells will not have dates, so it is returning a "invalid data type" error in those cells. HELPM3 formula: =DATE(VALUE(MID([SASH METAL OFFLINE]@row, 7, 4)), VALUE(LEFT([SASH METAL OFFLINE]@row, 2)), VALUE(MID([SASH METAL OFFLINE]@row,…
-
Formula Help - Index(Distinct(Collect
This discussion was created from comments split from: Extracting a list of unique value from reference sheet based on some conditions.
-
Nested Formula returning errors
Hi, Please help. I am pulling my hair out with frustration. I am trying to do a nested formula for data in two columns under different circumstances to return a Fail or Pass result. I have managed to do the individual formulas, but now cannot get them combined into 1 formula. It is to monitor the Fridge and Freezer…
-
Percentage Formula
I have this formula that calculates the percentage of items in a column where the check box "**Approved to Order" is checked, and it only counts items that have a quantity of 1 or greater than one. We are moving the check box to a Status column with many options, so I changed the formula but it is not working. Can anyone…
-
Formula for checkbox with dates
Hi there, I have a summary section in my smartsheet. One of the summary rows should highlight any fdob dates that are upcoming. There may be multiple items that will need to be listed in a single summary cell. I want the summary section to show 'Floor # FDOB Golive DD/MM/YY' by marrying the following items: fdob column -…
-
Formula
Hello, I am trying to find a formula that will allow me to have a count of running occurrences. For example, on the first occurrence of “A”, a 1 will show, then 2 for the second; 3 for the third occurrence, and so on. I know in Excel I can use COUNTIF, but when I try it in Smartsheet it returns the total number of…
-
Counting all children, including nested children
Hi - I think I have stared at this enough and tried many ways of sum and count formulas, but is there an easier way to count ALL the children of the highest outdented parent row which has multiple "sub-rows" with children underneath? I am trying to count the cells that are nexted beneath those rows and the children ()…
-
Can someone help me get a Countifs formula to work from another sheet?
I'm trying to get a countifs formula to work from another sheet. I've clicked on select from another sheet and copied the formula that works on the existing sheet but still can't get it to work. Here is the formula: =COUNTIFS({2022 Life Production}Rep:Rep, "Tim Crabtree", Status:Status, "Issued") The name of the other…
-
Any formula that can help me to calculate the number of the employee
Hi all, I am currently stumped by which formula to use in order for me to calculate the number of the employee. As you can see from the screenshot below, I was planned to calculate the movement of the employee in monthly basis. So, currently the formula that I using is: =COUNT([Joined Date]@row) - COUNTIFS([Last Working…
-
Value Lookup
I am trying to create a formula that uses that rows ID to look up on another sheet, if that row ID is used, to then use the info from the column. But I keep coming up with no match. =VLOOKUP([Project ID]@row, {Contractor Entries Range 3}, 7, false)