-
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…
-
Simple row multiplication formula
Hey all. Looking to have a row for an MSRP where the row shows the suggest 15% markup on a row. For example say row named COST is $100 and I want a markup of 15%, I want to create a formula to multiple COST row * 15% I am multiplying 1 row by a fixed number. I am not multiplying two rows together. What's the correct way to…
-
Simple sell date - buy date formula
Hey all. Trying to do a column equation that shows how long an item has been sitting on a shelf. Lets call the two columns Sell Date and Buy Date. I'd like to see the amount of days between Sell Date and Buy Date. If I bought inventory on 1/1 and sold it on 1/10, I'd like it to read "9' for "Days on Shelf" column. What's…