-
Counting Occurence of String of Text in a Column
Hi, I need suggestions on how to count string of text on a column. For example, i need to count how may GRC are there on the sample below: GRC Aer, GRC Aer, CDIR, GRC HTM etc. etc. Thank you!
-
Count Ifs Formulas
I need help figuring out why this formula is returning Invalid Data Type: =COUNTIFS([Conversion Status]:[Conversion Status], "Won", [Date Requested]:[Date Requested], MONTH(@cell) <= "3", [Year]:[Year], "2017") I want to count the number of lines that have a Conversion Status of "Won" that also took place in March of 2017
-
Formula
I am trying to write a formula that has multiple steps to it. I want it to see if the project is completed then to give me the Max date of completion.
-
If Formula
Good Day All: I am trying to create the following Formula however I am receiving an Incorrect Argument: If impact is High and Influence is High, then the Classification is Key Player My Formula: =IF(AND([Impact on Project]2 = "High", [Project Influence]2, "High", ="Key Player")) All help appreciated, Thanks!
-
IF Statement Help
I have a sales price database with one column for a retail price and another for a sale price. I'd like to make a 3rd column with a formula that populates the Save __% for our Marketing team. I made this formula which works with one small issue I'd like to resolve if possible. =IFERROR(("Save " + (ROUND(1 - ([Sale…
-
Comparing 2 date fields and setting symbol
Hi. Just getting to grips with Smartsheet. I have pairs of date fields: Forecast Date and Actual Date. I would like to set a red status symbol if the Actual Date is past/older than the Forecast date. How can I do this? Alternatively I can set a check box if setting a symbol is not possible.
-
If(and(countif equation question
Attempting to make a status bubble roll up where the parent will turn green if there are any blank ("") cells except for when all child cells are blank. Below are some of my failed attempts: IF(AND(COUNTIF(CHILDREN(), "") > 0, COUNTIF(CHILDREN(), "") <> COUNT(CHILDREN())), "Green") results in blank cell only when all…
-
SUMIFS criteria
Hi All, I'm trying to do a SUMIFS, and whilst I can return a result individually using SUMIF, when I try and combine I get #INVALID OPERATION. The formula I am trying to use is =SUMIFS({SERVICE DETAIL}, LEFT(@cell, 3) = "Col", {FEB 18}, {SERVICE TYPE}, "Transition", {FEB 18}) RESULT = #INVALID OPERATION If I separate it…
-
Need Formula - Total # of "Working Days" Left
Hello and thanks in advance for your help! I would like to automatically calculate the total # of "working days" left (as of today) by referencing the Due Date. I did find a formula for total number of all days left "=[Due Date]23 - TODAY()" but I haven't been able to find one that just calculates working days. Here…
-
SUMIF across a range
Hi All, I'm trying to use SUMIF to sum the total of all rows that meet a specific criteria * =SUMIF([SERVICE TYPE]:[SERVICE TYPE], "Monthly Charge", [2017-12]:[2018-01]) This however returns #INCORRECT ARGUMENT. Not sure what I am doing wrong. Any suggestions would be most appreciated. Regards Colin
