-
COUNTIF
Hi i am trying to count the number of projects "On Hold" and above 0% =COUNTIF([Install progress]:[Install progress], "On Hold", [% Complete]:[% Complete] > 0) but this is not working any help?
-
How to compare two cells for text to return a value
I have created a help column named Match. I want to look at 2 cells, check to see if the text is the same and return a text string of "Match' or "No Match". =IF(([Original Team]:[Original Team]@cell),NOT([New Team]:[New Team]@cell, "Not Match", "Match")) I keep getting an #UNPARSEABLE error. Thank you in advance.
-
Leaderboard Formula struggles
Hi, I feel like this is an obvious question but I can't seem to figure this out. I'm wanting to create a leaderboard to count how many miles people have competed in a competition. I have created a column with emails with a countif formula to count how many times this email has appeared in our entries but now want to create…
-
Find keywords in column
Hi, Any formula to find certain keywords in a column, and if it has it should say "Yes" ? I don't need to find any words, just key words, i.e. to find in a column that has 12345 & 98765, find all with a 234 string, if found, display "Yes" Thank you!
-
IF function with function result as condition
hi all; =IF([Link SO]@row = "#NO MATCH"; "Tersedia"; "Terjual") so i want to create this formula, if the condition cell contain "#NO MATCH" which is a result of INDEX function. it always result in "#NO MATCH" any input? thx update!..... edit sorry all. plz ignore. i have found the solution for those who found same problem,…
-
Conditional Formatting to exclude $0.00
Hello, I created a column formula that auto-create $0.00 for all empty rows, how can I create conditional formatting that will create a field RED if the number is negative and exclude all the rows with $0.00?
-
Round Function Freaks Out
I'm using the Round formula to reduce the amount of numbers in a total amount and then push it to a dashboard. See below: Total Value: $14,973,331 =(ROUND([Column34]3, -5)) / 1000000 =$15.0 While the formula does indeed work, sometimes Smartsheet has a total freak out moment and displays the incorrect value. This gets…
-
CountIf and Date formula combination
I need to calculate the number of roles in any given month. I have a seperate sheet with Hires, Roles, Start Date, and Productivity Date. The count should start two weeks after hire date , which is why there is a productivity date. In another sheet I want to calcule how many roles are active in any given month. The formula…
-
Return a value of Column A if a value in column B of different sheet is the same
hi; hope my english is comprehensible I have two sheet with some same column and quite a few different column. Say sheet X and sheet Y I want to use a formula for; return the value of column A in sheet Y if a value in similiar column in sheet X is the same with sheet Y. column A in sheet Y might be blank. which means the…
-
COUNTIF Formula
Good afternoon, I am trying to count the # of a specific category on a different sheet by YTD. Here is the formula I am trying to use. =COUNTIF({Category}, "Procedure", {Date},IFERROR(@cell),0)=YEAR(TODAY())). Not sure what I am doing wrong. Your help will be greatly appreciated. Thank you