Formula Column: Formula results with "empty" when a column has no status

I created a formula that summarizes my status column’s and their status’s (in one column). The problem I seem to figure out is when a status column doesn’t have a status, it creates the word “empty” in my summarized column. Is there a way to tell it, that if, that is status is blank, it doesn’t put anything in the summarized column. See my example below. There are 3 other columns to the left of the column called “ED” that have status’s.

P.S. I’m sure there’s an easier formula, I’m new at this extensive formula stuff! LOL

@mdavis

Welcome to the monday community.

When asking for formula help, it is best if you include the actual text of the current formula with the question.

One solution to your question would be to use the SUBSTITUTE() function. Something like this:
REGEXREPLACE(SUBSTITUTE(IF(....), "Empty,", ""), "(.*)." & ....


Jim - The Monday Man
:magic_wand: Column Magic :sparkles:- - the magical columns toolbox app

1 Like

When it comes to formulas…I leave it to the master :slight_smile:

@jim I thought I did in the picture. I can update it tomorrow on the community.

@mdavis

Yes, I can SEE the formula but I cannot edit it.

Good Morning Jim,

REGEXREPLACE(IF({AWV}, {AWV} & ", ", “”) & IF({DXR}, {DXR} & ", ", “”) & IF({TCM}, {TCM} & ", ", “”) & IF({ED}, {ED} & “, “, “”),”(.*).” & CHAR(123) & “2” & CHAR(125), “$1”)

This was another one I used. The above one wouldn’t work again, I had more cells to summarize.

CONCATENATE({Anthem}&" , “&{Village Health}&” , “&{Call Center}&” , “&{EHR Overlay: Huddle}&” , “&{EHR Overlay: Specialist}&” , “&{BP}&” , “&{CDI}&” , “&{HPSR}&” ")

@mdavis

Give these a try:

REGEXREPLACE(SUBSTITUTE(IF({AWV}, {AWV} & ", ", "") & IF({DXR}, {DXR} & ", ", "") & IF({TCM}, {TCM} & ", ", "") & IF({ED}, {ED} & ", ", ""), "Empty,", ""), "(.*)..", "$1")
REGEXREPLACE(SUBSTITUTE(CONCATENATE({Anthem}, ", ", {Village Health}, ", ", {Call Center}, ", ", {EHR Overlay: Huddle}, ", ", {EHR Overlay: Specialist}, ", ", {BP}, ", ", {CDI}, ", ", {HPSR}, ", "), "Empty, ", ""), "(.*)..", "$1")

Jim - The Monday Man
:magic_wand: Column Magic :sparkles:- the magical columns toolbox app

1 Like

Thanks Jim! They both worked! Exactly what I needed!

1 Like