NL(Sheets) error from options

I'm trying to create a Sheets function that will create a new sheet based on Subcontractor Valuations selected from a list on the options tab. When I run the report with an * in the option, it will produce a new sheet for all available values, however when I try to select 1 or multiple values, the sheets function returns a blank cell.

=NL("sheets","Subcontractor Ledger Entry","Closed by Entry No.","Company=",$C$3,"Job No.",$C$4,"Subcontractor",$C$6,"Valuation No.",$C$7,"Posting Date",$C$5)

any ideas?

Thanks, Graham


Please sign in to leave a comment.