Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I Have created a variable velapse and initiated it's value with 1500.
I have used this variable in input box and used this input box on my dashboard sheet for user to change this value as per thier need.
Now I want to filter the rows from a pivot table based on user input.
So for above requirement I have a text object and In select field I have given Jobname and search string I am passing as below.
='('& Concatenate(If(Elapsedseconds>=
$(velapse) , ' " '&JobName' " '),'|')&')'
I am getting only three jobs that are meeting above condition but there are more entries in the table that should meet above condition.
Did anyone else face this issue?
Please help
Regards,
PRASOON
Are you using the right function?
Shouldnt it be Concat function
I used the concat function only. My smart phone auto corrected that.
Can you share what the other fields in the table are
I slightly modified the above expression and it worked out for me.