-
Pulling in selected data from another sheet when conditions are met & then marking that as used
I have a complicated use case I could use some help with. Apologies if I'm using the wrong words here; happy to provide clarification. Here's what I'd like to happen: User submits a form to request a voucher for a specific exam. Row in SmartSheet 1 is populated with user's data. Upon row population, another sheet…
-
Count the number of projects per customer
Hi, This might be very basic, but I cannot figure t out. I have a long sheet showing among other things: but I can have 100 lines with the same Project number for the same customer. then a couple of lines for another project for the same customer etc. How do I count the number of different projects for 1 customer (and not…
-
Sum formula for Child cells
Hello Team, Please let me know the best formular to add up the values for Child cells, if some of the cells are blank or include 0 values. Below is a screenshot. I need to calculate the total value for each Region for the Stock Count. Many Thanks,
-
Calculating Dynamicly Average
Hi there , İ need a formula for a dynamic calculation , i added a sample as below , lets explain what i need ; At below table yellow field area contains August 2023 datas, white field area contains September 2023 datas , imagine that every each month , i amm adding new lines to this table also , So i have a dynamic tabe…
-
Results shows #UNPARSEABLE
Hello! I recently came across a very helpful answer from here: https://community.smartsheet.com/discussion/99468/if-a-value-in-a-cell-equals-the-same-value-in-a-column-from-another-sheet I have applied the formula to my sheet, but it was returning UNPARSEABLE. I tried another column and it works fine. Below is the value…
-
Matching Comma-Separated Values in a Cell Using Smartsheet Formulas
Hello Smartsheet community, I have a consolidated tracking sheet that captures details like vendor names, contract numbers, invoice numbers, warrant numbers, and vendor numbers. In my current setup, if a vendor has multiple contract numbers, they are all contained within a single cell separated by commas. This pattern…
-
Join collect based on date range
I have a helper column which works and collects expenses for events: =JOIN(COLLECT({activityname}, {name}, [Full Name]@row), CHAR(10)) output: CANS - AAN 2023 Advanced Method Conference - Registration - 09/13/23 - $226 NAHQ - National Assn for Healthcare Quality - Membership Renewal - 07/19/23 - $235 NONPF 2023 Fall…
-
Losing my mind...
I've been trying to figure out what to do with this formula and decided I've been staring at it long enough on my own. I'm trying to count the YTD total of resolution types of customers with Pick Planner and License Plate function types (customer has to have BOTH). I was able to use a similar formula for YTD total of…
-
Index/Match across 3 sheets resulting in #invalid value
Hi all, I have lots of experience with Index/Match in Excel and Smartsheet and this one has stumped me and I can't figure out why. Here's the scoop: I have 1 sheet (Sheet 1) where I import an xlsx document with a bunch of entries (with a PO Number, among other things); Sheet 1 would be my INDEX range for each of the…
-
Formula to auto populate contact column
Hello- We have a contact column where we select the Lead for an issue. This column is a contact list of our current leads. We can call this column "Key Div Dir." We then have an approval workflow that sends out requests to other peers of this division director. Each divisions director is assigned in their own column. Doing…