I have created a small report showing purchase orders. One sheet per purchaser. Now I want to use the report to mail to purchasers that have more than 2 purchase orders open. I have used the formel NL(Sheet….) so it automatically creates sheets per purchaser but how do I refer to a sheet which hasn't been created yet, when I make the small test (If sheet/field B7>2;xx@yy.com;"") in my mail reference sheet ?
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Hi,
I would recommend actually just creating another Jet function to replicate the purchasers with more than 2 purchase orders open rather than trying to get them from the replicated sheets. Your formula might look something like this (add whatever other filters you are applying on the other sheets obviously):=NL("Rows";"Salesperson/Purchaser";"E-Mail";"=NL(""Count"";""Purchase Header"";;""Purchaser Code"";""@@""&NF(;""Purchaser Code""))";"NUMBER&>2")
Does this help?
Regards,
Hughes
Please sign in to leave a comment.