-
Text in Date Column Messing Up Formula
I have 8 date columns where sometimes I enter text. Either the date of a document's expiration, or if the document was simply "received." I have another helper column that I want to be checked off if any of the 8 dates are expired. BUT I'm finding if I have text in any one of them, the formula becomes "invalid operation."…
-
SUM 2 COUNTIFS functions #INCORRECT ARGUMENT error
I am trying to sum 2 countifs functions and I am unsure why I am getting an error. I was hoping someone could help me fix this error. =SUM((COUNTIFS({Jade3_BCM Dashboard 2019 Range 1}, "Examine & Validate", {Jade3_BCM Dashboard 2019 Range 4}, "Execute on Timelines", {Jade3_BCM Dashboard 2019 Range 3}, "1st Quarter")),…
-
Countif on Formula Column
Can someone tell me what I'm doing wrong? I want to count all entries in a column that say 'Exceeds'. The formula I have in place is this: =COUNTIF([Q4 Performance]:[Q4 Performance], "Exceeds") The answer it is returning is the '#Invalid Operation' error. The only thing I can think of is that the entries in [Q4…
-
COUNTIFS multiple criterion
Hi All, Maybe somebody could help me to figure how does COUNTIFS formula works? I am trying to get summed cells which has specific naming from the drop down. I want to count "Dismounting" cells only if Column "Done" is not checked. At the moment I am typing formula in this way: =COUNTIFS({Type}; "Dismounting"; {Done}; "0")…
-
Will SUMIFS work with a date and a checkbox?
I am trying a SUMIFS formula without much success. The formula needs to return the Distance if Completed Date is before 31/03/20 and Signs has been ticked/checked. Distance (number) Completed date (date) Signs (checkbox) Is this possible? Thanks Faz
-
Recurring Weekly Tasks Formula
I have a sheet set up with a weekly task, a column for last completed date, and a column for next due date. I have a column that indicates the day of week that it must be completed on. I am trying to set up a formula in the next due date column that uses the selected day of week to update the next due date based on the…
-
Multiple criteria in a row for VLOOKUP
I am trying to create a report from data with multiple criteria in a row. The objective is to return the residual risk value for each combination of risk + strategic initiative. In Excel, I was able to accomplish what I am looking for with this formula (=VLOOKUP(CONCATENATE(D$2,"-",$B36),'FY 2020 ERM…
-
How do I reference different columns from another sheet in different formulas?
I am creating a sheet with formulas that include ranges in another sheet. The ranges are defined by column. It seems I can reference only one column across all formulas in my sheet. Whenever I go to change the range in one formula, it automatically plugs that same range into the other formulas. How do I create multiple…
-
Checkbox formula using =IF(OR
Hi, I am trying to find a formula to check a box based on another cell in the row having either maintenance OR support (along with other text) but keep getting an #INCORRECT ARGUMENT SET error. The formula works perfectly for one criteria i.e. =IF(FIND("Maintenance", $[Item description]@row) >= 1, 1, 0) but when I try to…
-
Does Smartsheets have a Google PERCENTRANK function equivalent?
Hello, does anyone have a solution for the excel / google function “PERCENTRANK()” or the “RANK” function. We want to consolidate our roadmap planning into Smartsheets and use one of these functions to automatically score from 1 to 10 each item in the list. The below image shows how this is done today in Google. The user…