-
Multiple IF Statement Returning Different Text
Hi Everyone, I am trying to write a formula that will look at a cell and if certain wording is not in the cell then return a value to a new cell. The information is from a multiple dropdown selection column. Here is an example of what i am trying to do. Dropdown List Would Populate the Missing Color column based on a…
-
How to count values if either of two conditions are true
I have two sheets: Sheet A and Sheet B I would like to count the number of cells in Sheet A, Column A and Sheet B, Column B that have the value "Liver". Both sheets are stored under the same folder.
-
Moving from 2023 to 2024
In 2023, our data was recorded by regions which then produced a President's report and Dashboard. Beginning in 2024, the data will be recorded as one company and not by regions. My sheets were originally set up with the help of a Smartsheet Professional so I am not sure how the formulas in the background are set up and how…
-
I need to count the number of enquiries between the dates 01/01/2023 & 31/12/2023
I need to count the number of enquiries between the dates 01/01/2023 & 31/12/2023 Just can't get the formula right, keep getting Invalid or Unparsable, I know it should be straight forward but...currently trying to use COUNTIFS I have the formula to count all the values that equal enquiry but can't set it to select between…
-
IF formatting combined with a calculation
I am trying to include a calculation only if a certain qualitative value is met. Trying to have the column indicate "Days Over Deadline" by subtracting the "Submission Deadline from the Submission Date," but only if the "Assessment Stage" is Issued. =IF([Assessment Stage]@row)="Issued", =SUM([Submission Date]@row) -…
-
IFERROR + IF/ISBLANK
This formula is almost perfectly pulling downtime by examiner and production date: =IFERROR(INDEX(COLLECT({downtime - downtime}, {downtime - production date}, [Production Date]@row, {downtime - examiner}, Examiner@row), 1), 0) There are a few records that are not in error, but the result is a blank, however, I need those…
-
Where do I put the IFERROR function to correct for year?
I have a column of dates. New rows are being added over time. I count how many occur in each month. In a separate metric sheet, have 12 formulas, 1 for each month, that look like this. =COUNTIFS({Date Column}, IFERROR(MONTH(@cell), 0) = 1, {Date Column}, MONTH(@cell) = 1) for January =COUNTIFS({Date Column},…
-
Consolidate Multiple Column Cells Into 1 Based on Cell Value in Row
I am working on a telecom cleanup project and have an export of all the telephone numbers at each site. I'm wanting to take the telephone numbers in each cell and combine them into 1 based on the branch number. The closest thing I could figure out was to run a collect function based on the branch number but am getting an…
-
Sum if status is approved and end date is in the future
I am trying to get the sum of approved projected expenses only. I can't figure it out I have been trying SUMIFS and SUM(AND formulas but can never get it to return a result. I can get one or the other to work, but it's important that only approved future expenses are summed. Below is a screenshot of the columns I'm working…
-
COUNT(COLLECT) Status and Dates
Hi Super Guru's, Could I kindly ask assistnace on where my formula is incorrect. Getting #UNPARSABLE error =COUNT(COLLECT(Status:Status, ="Complete"),[Finish Date]:[Finish Date], >=DATE(2024, 1, 1), [Finish Date]:[Finish Date], <=DATE(2024, 12, 31)))