Creating INVOICE. JOIN and make blank as 0
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
Answers
-
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
-
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 -
- create extra column in original sheet
- 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!!!!!
-
Most wondersfull, no doubt. I`m happy i found it
-
I'm glad to hear you were able to find a solution! 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!