Formula is not copying

paulen

Hi, I am having a problem with one formula that is not automatically copying to a new row (there are others that are being copied). The formula is:

=JOIN(CHILDREN([Column Name]1, ", ")

Why every other formula is being copied but not this?

 

Thanks.

Andrée Starå

Hi,

Strange!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

paulen

Hi, thanks for the reply.

I shared with you.

Andrée Starå

Thanks!

I'll take a look and get back to you!

Andrée Starå

Happy to help!

If I understand what you want to do you must use and add an Absolute Reference ($).

=JOIN(CHILDREN($[Ações (O quê?)]$5), ", ")

More info: https://help.smartsheet.com/articles/2476816-create-cell-column-reference-formula

Did it work?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée

paulen

Hi, Andrée!

No, it is not the case of Absolute Reference.

If you do a simple test you will see what I mean:

Enter something below the yellow cell and press Enter: the formula at the column "Riscos Impactados" is copied.

Do it again below the "something" and press Enter: the formula is NOT copied.

I hope it is clear now. Thanks!

Andrée Starå

Ok.

I tested and I see what you mean now. Strange!

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Andrée Starå

But, it worked after I saved the sheet so it's working. 

paulen

It works for little time. If you include rows and new hierarchy it stops working! I have 20 sheets with this same problem!

Andrée Starå

Ok.

I'd recommend checking with Smartsheet Support.

Let me know how it goes!