-
Excluding and Including data in a countifs formula
I need the total number of that meets the following criteria - Banner Name, Open, and not MA or NY. I am able to write the countifs to include the specific banner name and whether the status of that site is open, but I can't figure out how to exclude certain states or include certain states. This is what I tried below…
-
Formula for Name separated by Commas
Hello, Is there a formula that can give me all of the text to the left of a comma and all of the text to the right of a comma? I have a list of names and my LEFT FIND formulas aren't working correctly. For example, My list has names like this Adam, Smith Susan-Anne, Smith Bob, Wilson I need a First Name Column and a Last…
-
Data Shuttle Conditional Formatting?
Hi all, I had a chat with Pro Desk, and they couldn't come up with an answer for my question, so I'm turning to you all :) I have an Excel data source with project information that I receive every two weeks. One row = one project. One of three things could happen to this data source: Existing data updates Data is added as…
-
Last value of a row that is not empty
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history of the data. columns (date type) can contain a value or be empty. I need to get the last updated date for each project (not…
-
Using "IF" with "And" for multiple criteria
Hello, I'm struggling with the syntax for a formula-I've seen examples within the community and can't quite get them to work properly for me. I would like to count the following: Count values where the following statement is true: column 1 =ABC, or, DEF, or, GHI AND where column 2 =123, or, 456 I've tried =COUNTIF([Column…
-
Symbols Formula Not Working Right
I am trying to get a formula that will put symbols in under the following conditions: If greater than 25% Blue, if between 20% and 25% Green, if between 1% and 19% Yellow, if less than 1% Red, if blank than blank. The formula I entered seems to work EXCEPT that the range between 1% and 20% is showing as Red instead of…
-
PI Formula
Hi, i was wondering if there is a option to use PI in a formula within Smartsheet's. i am trying to get the below formula to work it currently working in excel. 0.19793488158659*180/PI() any help will be great to get this to work on smartsheets.
-
If / isBlank statement
I am having a total brain cramp and cannot figure out the formula I need for this. two columns: Task Status Closed Date There is automation setup that when someone marks a row as Task Status = Completed, it should capture the date and put it in the Closed Date column. Well, that automation works 90% of the time, but we…
-
Working days between two dates
Hi, I'm looking to use the networkdays forumla to calculate the working dates between my date column and the oldest column for each individual, I can't understand why the formula isn't working. I have set holidays to zero (and changed it to a number) and its still unparseable. Can anyone assist me with the correct forumla,…
-
Counting number of values from one multi-dropdown to another
Hi All, Hoping someone can help me with a COUNT formula please. I have 2 multi-dropdown columns and I'm wanting to count the number of selections from one column that appear in the other. To give a bit of context, Column 1 could have "A", "B" and "C" (but potentially many options), and Column 2 could have "A" and "B". I…