Hello all, I am new to Smartsheet and this community, so I apologize in advance if my question has been asked and answered numerous times already. I just couldn't find my answer. Here it is anyway: I …
So I'm having an issue (lack of understanding) on how to use join/collect to turn a sheet like this: Into one that combines Qty/Supplies into one line item based on data from multiple other columns. E…
I am looking to cross reference Sheet A to pull in Time slots from Sheet B. Criteria I need to have matching from Sheet A to pull from Sheet B to determine the slot number or multiple numbers. Start T…
Hi, I'm trying to do something a bit complicated and hoping for some assistance. I am trying to join text from specific columns IF another column has specific verbiage in it (Campaign 1). Below is an …
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell bas…
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is wher…
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our…
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown…
The question seems simpler than the outcome I'm hoping for. I need to combine distinct project types from multiple columns on multiple sheets. I know I need to use Join, Collect, Distinct, and potenti…
I have a dropdown column (multi-select) that lists participating districts. Each row is a different program that can have different districts or sometimes the districts repeat. I am trying to count ho…
