-
Number in between 2 values
I have a range of numbers that correspond with a tier level. I have figured out Tier I and III, but I'm not sure how to account for Tier II being between 2 values: >21000, <40000. =IF([AVG. STORE UNITS]@row <= 21000, "TIER III", IF([AVG. STORE UNITS]@row >= 40000, "TIER I")) I appreciate any and all help!
-
Help with Formula for Counting Unique Values
I created a tracking spreadsheet for our annual law school on campus events and on this spreadsheet, we list within the same column all of the attorney participants we send on campus for that law school. There's usually between 1-4 attendees per event and within each row. If there are multiple attendees for that event,…
-
extract the SUM of projects from a certain date range on differnt sheet
Hello All, Im trying to figure out how to extract the SUM of projects from a certain date range. Essentially I have a Sales funnel and want to find the the revenue forecasted within a certain date range. IM also new to the this so and completely lost
-
Create cross sheet references to work with data in another sheet
I have five individual columns that I would like to cross-reference with another sheet on Smartsheet to get specific information. For example, In Smartsheet A: I'm collecting data on when front-line staff call in absent, each employee can get a drop-down menu to get to the specifics of why they're unable to attend work.…
-
#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!
