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

Platform discussions Special workflows & use cases
,
1

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

Formula
Formula763×210 14.9 KB

2

@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
3

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

4

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

5

@mdavis

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

6

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}&” ")

7

@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
8

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

1 Like
9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.