-
How to get sum of number of events for the client Delta
Formula I tried: =SUM(Client:Client = "Delta", Events:Events) Then I also want to be able to count the number of events per fleet: "B757/767"
-
Show approval status based on # of approvals vs. denials
I'm looking for a formula that will show "Yes", "Hold", or "No" based on # of approvals. There are 6 total approvals needed, if all 6 approve, then the Approved column would show "Yes". If there is 1 or more denials, then the Approved column would show "No". If the total of the columns don't equal to 6, then the Approved…
-
COUNTIFS Formula Question
Hello, I am trying to create a COUNTIFS formula to determine how many stops by Sales Rep, By County, By State. I have created helper columns listing the counties in each state. The formula I have is: =COUNTIFS(County:County, [Mark Counties]@row, State:State, "OK", Date:Date, YEAR(@cell) = YEAR(TODAY())) It is pulling a…
-
Need help with pulling contacts from another sheet
Hi. I have three different agencies that have a list of employee names and email addresses. When I do data entry into Smartsheets, I am trying to pull the list of the agencies email addresses into the form so I can send them an email. Here's the formula I have so far, but I'm getting an #incorrect arguement set.…
-
Automation between sheets
I am having an issue with an automation. After an approval request gets approved, it records a date on one sheet, whose information is linked by a formula to another (main) sheet where there is an automation that if the cells in that linked column are a date, then it triggers a check in a check column (Active). The…
-
Complex JOIN(COLLECT())
Hello all, I'm hoping to use a formula to return a JOINED list of shared USERS for all sheets in Sheet 1. I have three additional sheets that contain all the supporting data, but since I don't want group names, is it possible to perform the user lookups from the groups sheet within the COLLECT function? Sheet 1: A list of…
-
Counting people
Hi Smartsheet Community I use smartsheet to manage volunteer opportunities for my organization. One sheet details the employee, event, date, etc. for the whole year. I want to find out how many total employees volunteer without having to go through the entire list and cross out duplicates. Any tips on how to do that? thank…
-
Not Exact Match
Hello - I am using the below formula to bring in the names from another sheet: =INDEX({Company Name}, MATCH(Name@row, {Name Column}, 0)) This is the example for reference: My question is if there is something that I can add to my formula that looks for a similar name. The data set i'm looking at the reference sheet isn't…
-
Formula help
=IF([WD Schematic End]@row = "n/a", 0, IF([WD Schematic End]@row > [STR Schematic End]@row, 1, 0)) Above formula meant to trigger a red flag if the WD & STR Schematic End dates do not match. The formula I wrote is pulling back 'invalid' ... I am missing something and cannot figure out what!
-
Formula to display multi-select options separately
I want to use the same formula, but instead of adding number amounts, I want it to display multiple selections in another column. Currently, tried this: =IF(CONTAINS("- Joining neighborhood-based, in-person adult learning house parties", [22/23: Torah (Learning) Commitment]@row), "Jewish Journey") + IF(CONTAINS("-…
