-
using OR and multiple expressions
I created this statement using OR and CONTAINS to select a value between 2 expressions - Stage 1 or Stage 2: =IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row)), IF([Example Result]@row >= -30, 1)) This works fine for recognizing and providing results for Stage 1 & 2 logical expressions. I want to…
-
Formula used to populate date column won't trigger date based automations
I am using a formula-generated date in a "Date column" to run an "alert someone" automation as a reminder for follow-up. I am using this automation setup set to alert me when the date is today. When I hand enter a date in the column the automation works as expected. I believe this is a result of the automation still…
-
Using the COUNTIFS to determine quantity for feedback
Hello, I am trying to determine a count of a Theme and Sub-Theme but do not seem to be able to since the Sub-Theme column is a multi-select dropdown. Any advice on how to do this? Currently, I am using the following formula: =COUNTIFS({Range 1}, "Theme Name", {Range 2}, "Sub-Theme Name")) The only time the formula is…
-
Count months in another sheet but only within a certain year
I have one sheet with dates listed (ex: 9/10/21) that range from 2020, 2021, and 2022. I'm using this formula to count how many are in each month: =COUNTIF({Head And Neck_Project Overview Range 1}, IFERROR(MONTH(@cell), 0) = 1) But I'd like to break it down by year so I'd like to find how many are in January of 2021 only.…
-
Create SUMIFS formula with a contact criteria in a multiple contacts range
Hi, I am looking for the right way to build my formula that makes a sum of a number column with a contact criteria in a multiple contacts range. Example: =SUMIFS({numberRange with hours}; {Criteria Range with multiple contacts}; Contact Name; {Range with Statuscode}; "In Progress") Check also the screenshot below. If I…
-
Countifs that also exclude a parameter
So I am trying to do a countifs report that counts if something has a name, a ranking and then to not count if the status is complete. I have it working to count if it has the name and ranking, but when I try to get it to not count them if they are marked complete it does not work. The working formula: =COUNTIFS({Third…
-
I need help building a formula
I have a sheet where I have different alpha numerical items listed such as F556 L, and F557 G, as these are completed I want the completed alpha numerical placed in a second column and then a third column that subtracts the second column from the first leaving only the items that are not in the completed column. My current…
-
If contains & Index Collect Formula
I am new to Smartsheet. Top is my data set from another sheet, bottom should be the result that is located in another sheet. been trying to formulate but always end up with unparseable. I hope someone can help me. Thank you.
-
Excluding multiple options from a COUNTIF..., istext@cell
I have a column where I want to count any entry which I used a , istext(@cell), however now there are entries that I want to exclude, I used the formula below for my Sheet Summary 'Count of Routes' =COUNTIF(Route:Route, ISTEXT(@cell)) - COUNTIF(Route:Route, "AVA IC / Dispatch") But now I am getting additional entries that…
-
SUMIF(CONTAINS...
I'm trying to gather info from another sheet but keep getting the "Unparseable" error message. Basically, I want to add the total amounts of any rows that contain "1st" as the district. The column that has the district information is a multi-select value hence why the contains. The current formula is set as: =SUMIF(…
