0

NL(Sheets) - worksheet name

Jet Reports Historic Posts

January 28, 2016 09:51

None

Follow

Hello,

I'm using a formula that looks like =NL("Sheets";"Production Order";"Sales Agent Code"). When running, it will create a sheet for each Sales Agent Code, adding the code as the worksheet name.
How could I add some additional description to the worksheet name?
I would need that the name would look like "ACD NB", for example (where "ACD" is my "Sales Agent Code", and "NB is a text I added"). The "NB" text should be added for all the "Sales Agent Code".

Thanks!
Elena

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts January 28, 2016 10:08

  Try something like this:
  
  =NL("Sheets";"Production Order";"=NF(,""Sales Agent Code"")+"" NB""").
  
  Just make sure if you're using the cell as a filter in another jet function that it won't match now.

• 0
  
  Jet Reports Historic Posts January 28, 2016 10:25

  Thanks, Teresa!

• 0
  
  Jet Reports Historic Posts February 16, 2016 21:12

  You can also concatenate NL functions or strings using the ampersand "&".
  
  =NL("Sheets";"Production Order";"=NF(,""Sales Agent Code""))&" NB"
  
  I did this in a report this morning: =NL("First","Sales Invoice Header","Sell-to Customer Name","Order No.",B7)&" - "&NL("First","Sales Invoice Header","Sell-to City","Order No.",B7)&", "&NL("First","Sales Invoice Header","Sell-to State","Order No.",B7)
  
  So, I'd get "Customer - City, STATE".