-
Getting Same Resutl with Slightly Different COUNTIF
Hi Guru's, I run the below formula and it gives me the correct number however; I modify the formula to look at another range however; I get the same result as the first formula minus the 2nd range. 1st formula =COUNTIFS([Operational Priority]:[Operational Priority], ="🔶", Status:Status, "In Progress") +…
-
Need help with Nested If Statement
I need some help with a nested formula. I've spent hours on this and cannot seem to get it to work. I'm basically looking for the following function: If date column 1 and date column 2 are not blank, then, If these dates (date column 1 and date column 2) are the same, enter 0, if not, return the number of days between the…
-
Countifs not working for project by month
Hello all, I want to count 3 different project types, by the number our team does each month. Two of the 3 project types are coming back with data. Why am I getting an error on the other? Here is a snippet: I keep getting the invalid data type error on it.
-
Searching keywords from a list of words?
Hi, I have two sheets, say Sheet 1 and Sheet 2. Sheet 2 contains a list of words in one column (i.e. "Keyword"). Sheet 1 contains a column with status updates (i.e. "Comments"). I would like to set up a formula that searches if Sheet 1's "Comments" column has any matching keywords from the list of words hosted in Sheet 2's…
-
Get dates and conditional sum of budget spreads
Hi Community. I have a spread of budgets but I want to retrieve the start and finish dates of the spread AND I want to get the planned sum of the spread up to a given date. Here is a print screen of the simplified table: The Start Date and Finish Date columns is supposed to have the formulas that read the start date and…
-
I need an averageifs formula but it seems as though that is not an option is there a work around?
I need the average of my survey results if the created date falls within a certain time period as well as if well as team participation. The following is subset of my data.
-
Having trouble comparing two cells
I'm having some issue with comparing two cells in my Smartsheet. I want the box to be checked if the cells match, and if not, the value of the one on the left should turn red. I have 8 sheets for 8 different budget accounts that are all based on the same template. This works for every one of them except for this one. In…
-
Formulate % Complete for Stages on Dashboard
Overview: I have a sheet with a number of equipment items for my team to collect and log. The data is split into 3 stages. (Stage 1 = Sky blue, Stage 2 = Medium blue, Stage 3 = Grey) If the data has not yet been gathered the column with populate a 'N'. The project team will change the cell to 'Y' if field is complete, or…
-
Can I link 2 sheets with a formula that feeds many date columns?
Dear All, would you please advise if this is possible? if yes, would that be a combination of JOIN/ COLLECT/ IF / AND? If no, is there a way around it? I need the dates in these 10 columns: to feed into these 2 date columns: The condition is that Discovery Start Date has to feed into Phase Start Date when the activity is…
-
Struggling with COUNTIFS and CONTAINS
Hello! I have read through a bunch of questions about COUNTIF and CONTAINS formula but none seem to be working for me. I have a metric sheet in which I need to count the number of projects in a particular status for a particular business unit. The business unit field on the source sheet is a multi-select field, projects…
