-
#unparsable error when using =IF(AND
Hello. New here! :) I have an =IF formula that works fine with one set of information, e.g. =IF(AND(Calculation14 > 0, Calculation14 < 3), "Continue as planned") But I want to add other options, such as: =IF(AND(Calculation14 > 0, Calculation14 < 3), "Continue as planned"), =IF(AND(Calculation14 > 3, Calculation14 < 9),…
-
Sum numbers in a column based on week ending filed -5 days
I have a Column called Total Overtime Hours and a a column called week ending which has a date in it. I am trying to sum all the overtime hours by the week ending - 7days I'm doing this calculation in the sheet summary tab. Here is what I have been trying to get to work =SUMIF([Total OT Hours]:[Total OT Hours], ([Week…
-
Count distinct values based on other cell criteria
I have been able to figure out how to count distinct values in a column. Now I would like an additional complexity of asking the formula only to count cells if it meets the criteria in another column. If the value in the Status column is 'Live', count the distinct number values in the UniqueDiseaseID column.…
-
INDEX/DISTINCT with multiple criteria
Hello, I am trying to create a formula that will pull in a distinct text with multiple criteria. I do have a helper column. The original formula I used works in a different scenario where only one criteria is met. =INDEX(DISTINCT({CLT}), Number@row) But now I want to create one that pulls in "SegAddy" when "RTRD" box IS…
-
Count the number of submissions in a particular year
How can I do a Countif Formula that would collect the employee payroll number and count how many times an agent has been absent for ONLY 2023. One issue I'm having is collecting previous years, such as 2022. I only want it to count as 2023.
-
Sum of A Column based on a specific criteria
Hello All, I am trying to build a budget forecasting sheet. I would like to have a summary that would add up all the replacement costs for items that will be replaced in 2023 and then again in 2024. See photo. Any help is greatly appreciated!
-
Looking for Help on multiple criteria IF formula using full columns
Hoping someone can help: If conditions meet the below criteria, then Program Health result be be "Red" if not result would be "Green" 1st Requirement: Column "Essentiality" = "No-Go" 2nd Requirement: Column "Status" has at least one "Red" OR Column "Status" has 3 or more "Yellow" Sorry I am new to smartsheet and struggling…
-
Did a date formula change?
=DATE(YEAR([Last Month]@row) - 1, MONTH([Last Month]@row), 1) =DATE(YEAR([Current Month]@row), MONTH([Current Month]@row) - 1, 1) I have been using this above formula for the last 6+ months in 20+ sheets but I noticed it is not working anymore. Did something change or do I need to update something since the year changed?
-
Multiplying Number in One Column, Result in Next Column
Hello, I am trying to create a function to take a number from one column, multiply by a set amount and to return the result in the next column, but I am not finding an easy function for this. I am familiar with doing this in Excel, but not SmartSheet. Thank you! Jackie
-
I need help with COUNTIF formula when referencing another sheet
I have a 'main' grid that contains my detail (945 rows) where each row has an employee ID, QuarterEnd, and Quarter fields. The QuarterEnd is populated with 12/31/2022 or 03/31/2023 and I'm using a nested IF statement to arrive at the Quarter to display as Q4-2022 or Q1-2023. I'm calculating metrics in a separate sheet…
