Formula Not working adding a 0

Jon Barto

Hello I could use some help with this formula.

Here is the formula I am using the bright yellow column to hold the formula. so you can see the results of that formula below

=IF(ISBLANK([Initial Approval Date]@row ), " ", [Homeowner Approval Initial Status intake]@row + [Homeowner Approval Initial Status Intake 2]@row + [Homeowner 1 Email approval]@row + [Approval Status 3]@row + CHAR(10) + [Initial Approval Date]@row )

Only issues I am running into is when the approved is in the "homeowner 1 email approval" or "approval status 3 column" it puts a "0" infront of everything. If the approval is in homeowner status intake or homeowner approval initial status intake 2 it works fine.

What am I missing here?

Thanks so much

jmyzk_cloudsmart_jp

Hi @Jon Barto

As I tested, if I tried to add to blank cells, Smartsheet considers it as an add, not a join. For example, in the second row, since Column2 and Column3 are both blank, Column2 + Column3 = 0; whereas in the first row, the same Column2 + Column3 is Blank "A", so Smartsheet considers it a join and returns "A".

https://app.smartsheet.com/b/publish?EQBCT=7678a36fa528468fb1a1b9b0c5f411e9

To avoid the above behavior, you can use the JOIN function.

=JOIN([Column2]@row:[Column5]@row) + CHAR(10) + Date@row

Or, in your case, move the 'bright yellow column' outside the JOIN range, and use a formula like this;

JOIN([Homeowner Approval Initial Status intake]@row:[Approval Status 3]@row)
+CHAR(10) + [Initial Approval Date]@row