Iโm trying to use a de-reference to look up all inputs from a specific user on a certain date.
Iโve had the user input their name, and the date they are looking up and I would like a drop down list of all orders filled by them filtered by the previous columns of name and date. Any help?
What do you have currently?
Try with thisโฆ
SELECT(TableName[Order],AND([NAME]=[_THISROW].[NAME],[DATE]=[_THISROW].[DATE])) in Valid_If.
@Aleksi_Alkio Youโre seriously the best!
@Steven_Coile the above solution worked. I do know that lookup functions like this have performance drawbacks. So if you have any solutions that strictly uses appsheetโs de-reference abilities, that would be cool to. For now this method works!
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |