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

Volodymyr L

Good day Genevieve P.

Thank you very much for answer

Automation is cool but i want to have more stable way - setup the JOIN(COLLECT()) formula from another sheet

I found this answer -

1. create extra column in original sheet
2. make the formula like - =IF(ISBLANK(Time@row); "-"; Time@row)

I have another important question in another thread and one more thing

YOUR SMARTSHEET programm IS THE MOST WONDERFULL programm in the WORLD!!!!!

Volodymyr L

Most wondersfull, no doubt. I`m happy i found it

Genevieve P.

I'm glad to hear you were able to find a solution! 🙂