Removing blanks from a JOIN COLLECT formula

System

System Employee

08/09/24 in Formulas and Functions

This discussion was created from comments split from: Need help removing blanks from a join collect formula.

0 ·

Answers

AnneSh ✭

08/09/24

I am trying to achieve this but struggling still…
=JOIN(COLLECT([SAT A]:[SAT 1], @cell <> "", [SAT A]@row:[SAT 1]@row, ","))

0 · Share on Facebook Share on Twitter
KPH ✭✭✭✭✭✭

08/10/24

This is a duplicate post. I responded on the other thread with the same question, see:
https://community.smartsheet.com/discussion/129188/help-removing-blanks-from-a-join-collect-formula

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Need Help with a Formula
I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow I've tried a few things but can't figure it out. Can anyone help?
Count the number of times a person's name appears in an "Assigned To" column
I currently use the below formula to count the number of times a name appears in the "Assigned To" column. The issue is that this column can have multiple names in the same cell, so I have to created a separate formula for every possible name combination. Is there a way to have a formula that looks for a name string and…
Equation to fill in "On time" or "Late"
Hello, I am trying to create an equation that will generate on time or late depending what the quoted delivery time is and the real delivery time is. I have been able to get thus far but I want to include a parameter so if it is 5 minutes or less late then it will say on time. For example if a quoted time is 9:00 and the…