-
How to not skip ranks and deal with ties?
Hi all, I worked with the Prodesk on using the RANKEQ function which was helpful, but I am realizing I have records which are ties. Essentially I have a column which ranks our projects; if the weight is 0 it's "not ranked" and should be thrown out of the rankings, if it's anything else it's ranked. The formula is as…
-
Calculate average time
Hello, I am trying to calculate average duration time for a date range. For example, on Monday I spent 23 min doing a project, on Tuesday I spent 35 min, on Wednesday I spent 15 min, etc. what is my Weekly Average? When I enter the data as 0:23, 0:35, 0:15 and do an AVG formula, I get an error message. Any suggestions on…
-
If Statement with nested VLOOKUP formula
Hi! I would like to return a value from another SmartSheet if one column in that same SmartSheet has a "Y". I have the current formula below, but it's returning a #NO MATCH error... any thoughts? In summary: return value in column A of SmartSheet Y to SmartSheet X if coulumb B in SmartSheet Y = Yes.…
-
Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…
-
IF formula Unparseable error when using strings
Not sure what is going wrong here, as I’m getting UNPARSEABLE error when using the formula below. =IF([Risk Rating Calculation]@row<5,”yes”,”no”) If I were to use numbers instead of the strings “yes” and “no” I do not get any errors (example below). =IF([Risk Rating Calculation]@row<5,12,10) -> This does not give any…
-
i have 2 formulas to count entries from multiple pages into a totals page, one gives me an error?
i am counting how many times employee "A" has done a certain task in category "A" (30 days) on multiple sheets, and how many times employee "A" has done a certain task in category "B" (60 days). one formula works, the second formula works when the name is different, but not when the name is the one i need. it works with…
-
Referenced Sheet Hours Calculation Incorrect
I have a time report that works on the time method of 1 = 1 hour, 0.25 =15 minutes, 0.50 = half an hour, 0.75 = 45 minutes, etc. If I do a SUM calculation within the sheet, I get the correct amount of time i.e. 37.50 for one week. However, on a metrics sheet, I am trying to calculate from this referenced time report, the…
-
Referencing Dots and Status in another worksheet
I need to reference these two columns from sheet B onto Sheet A. I want to display worst case from sheet B on Sheet B. Example: Project 1 on sheet A will display the worst case (At Risk and Red dot) from all rows on sheet B. What are the two formulas I need? Attempted using an Index formula but was unsuccessful.
-
Divide By Zero Error
Hi all, As you can see I have done a sheet that calculates % of each quarter. Is there a way if blank for one of the quarters that it will not return Divide by Zero error?
-
Is there a way to use Datashuttle on a report?
Hello all, I have a report that I want to export into a google sheet, however, I am unable to find the report when I use the Datashuttle process. If this is not possible, is there a way to import the range from the report to a normal sheet? I have already tried Datamesh but I wasn't able to get it to work. Any help is…