-
Invalid Data Type on an IF function with Index Collect
Hi All, I am trying to nest and index collect into an IF but I keep on getting Invalid Data Type. =IF(INDEX(COLLECT({Tracker - Range 5}, {Tracker - Range 2}, [Project Name]@row, {Tracker - Range 5}, "LATE"), 1), "LATE", IF(INDEX(COLLECT({Tracker - Range 5}, {Tracker - Range 2}, [Project Name]@row, {Tracker - Range 5}, "Onโฆ
-
How to use COUNTIFS where there are 3 conditions (columns to be referenced)
I'm trying to create a formula in a metric sheet that is referencing another sheet where data is held. I've been able to set up a COUNTIFS formula that references 2 columns so far, but my issue is that it doesn't seem to let me reference a third column using the "formula builder" as below: I'm trying to use COUNTIFS toโฆ
-
WEEKDAY function returns incorrect day
I have the following formula setup to capture the day of the week: =IFERROR(IF(WEEKDAY([Date Created]@row) = 1, "Sunday", IF(WEEKDAY([Date Created]@row) = 2, "Monday", IF(WEEKDAY([Date Created]@row) = 3, "Tuesday", IF(WEEKDAY([Date Created]@row) = 4, "Wednesday", IF(WEEKDAY([Date Created]@row) = 5, "Thursday",โฆ
-
Clearing just the #DIVIDE BY ZERO cell result without clearing out cells that do have data.
=IFERROR(=([OPT K B]@row - [NONOPT K B]@row) / [NONOPT K B]@row, "") I'm trying to summarize a column that cells contain both a percentage and a #DIVIDE BY ZERO result. I added a IFERROR to handle the #DIVIDE BY ZERO (clearing it) but it also clears any cell that contains a percentage. I rather have the column formulaโฆ
-
How to add 4 months to a date
Hi there, I'm trying to figure out when the 4, 8, & 12 month reviews are due for my staff. I have this formula: =DATE(YEAR([Start Date]@row), MONTH([Start Date]@row) + 4, DAY([Start Date]@row)) BUT it only works within the year, so if someone starts in November, it will not work (obviously as we are adding 4 months, butโฆ
-
>=1 and <=20
how do i make write a formula for a count if the number is greater than or equal to 1 but less than or equal to 20
-
Update status in another smartsheet
I have an asset register, each with a unique asset number that also holds a status (In service, out for repair, decommissioned) I also have an asset damages log where an asset is reported as faulty or damaged and is sent for repair. If unrepairable it will then be decommissioned. My question is....... how to I update myโฆ
-
rolling 12 month formula
This discussion was created from comments split from: Need Help with Formula for Rolling Metrics.
-
Getting MEDIAN to work after IF statement
All data is in the same worksheet. Days to Live is a column formula calculation that usually has a number, but sometimes an error, because there is no live date and it's a column formula (this is fine for me as I don't show it directly). =MEDIAN({Days to Live})ย works fine, even when there are records included that have noโฆ
-
How can i count values over a certain number for valid results only
I have 7 columns. Grab 1 Result, Grab 2 Result, Grab 3 Result, Grab 4 Result, Grab 5 Result, Grab 6 Result and Valid Results I need to count the values greater than 200 if the valid result column = yes. if the formula can be used for each column 1 through 6 in the sheet summary, I can just Sum to get my total. I assumeโฆ