Creating INVOICE. JOIN and make blank as 0

Volodymyr L

Good day

I have created pipeline of creating multiply invoices, documents as automation

But i have few questions. One of critical problem is

If the first task has 0 hours - i miss the cell and the next number is located near wrong task ( or artist )

The problem is only if we have first cell as 0

My formula is

=JOIN(COLLECT([Столбец 2]7:[Столбец 2]13; [Основной столбец]7:[Основной столбец]13; =[Столбец 4]@row); (CHAR(10) + CHAR(10)));

Very common formula. I don`t understand how to add IF ISBLANK for this situation

Genevieve P.

Hi @Volodymyr L

What I would do in this situation is have the cells in your first sheet automatically populate with 0 if they are blank. You could use an automated workflow for this, see: Change the Value of a Cell in an Automated Workflow

That way your JOIN function will have a value to bring together.

Cheers!

Genevieve