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

Days to go formula
I have a dedicated column "days to go" I'm trying to get the formula to take the networkdays between today and the start date (accounting for dates in the "holiday helper" column. This formula works but gives a negative number. If the date is 5 days in the future I'd like it to read 5 not -5. If in the past be negative,…
Index Formula with CountIFS Running Total
Hi - trying to make a Training Matrix for my company. "Matrix" sheet has the following columns: Row: (Auto-Number) Doc ID: (Text = document needing to be trained on) Employee 1: Check Box if they need to be trained Helper: column formula to give running count of checked boxes =COUNTIFS([Employee1]:[Employee1],…
Formula for COUNTIFS and Dynamic Date Range
Hi Smartsheet Community, I am really struggling to get the right formula and have tried so many now I am losing it! I am trying to prepare dashboards for weekly project meetings based on SLAs. I need to look at the count sitting in a particular status that have a Contract Date of >28 days, 14-28 days and <14 days. Because…