What is your goal?
I need the google sheet to output the right data from the sheet.
What is the problem & what have you tried?
when a new option comes in from the form and its put as a filter in the google sheet(search rows), its not bringing an output for the last 3 rows incases when the option from the sheet is any of those 3. but if the options is any of the 9 rows above those, the right outputs come out. Its very confusing because its all on same sheet. I’ve tried using several functions to trim, replace and lot more but all to no avail. I will be glad if anyone can be of help. Thanks
Screenshots (scenario flow, module settings, errors)
