I need to filter data by column and get Maximum value for the same. I’m enter the following code to the excel sheet.
<<Start:Filter
(“Master DB”,
AND(
[Creare Proposal?]=“Y”,
ANY(
TOP(
SORT(Master DB[Timestamp], TRUE)
, 1)
)
)
)
<<_RowNumber>>
Appsheet had encountered following error.
Failed: Action not performed because 2 errors are present. Error: Workflow rule ‘Prep Proposal data’ action 'Pulling proposal data ’ Attachment template. Expression ‘Filter (“Master DB”,AND([Create Proposal?]=“Y”,ANY(TOP(SORT(Master DB[Timestamp],TRUE),1))))’ is invalid due to: Condition AND(([Create Proposal?] = “Y”), ANY(TOP(SORT(MASTER DB[Timestamp],“TRUE”),1))) has an invalid structure: subexpressions must be Yes/No conditions. Error: Workflow rule ‘Prep Proposal data’ action 'Pulling proposal data ’ Attachment template. Start expression ‘Filter (“Master DB”,AND([Create Proposal?]=“Y”,ANY(TOP(SORT(Master DB[Timestamp],TRUE),1))))’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table…
Solved! Go to Solution.
Try:
<<Start: LIST(
MAXROW(
“Master DB”,
"Timestamp",
[Create Proposal?]
)
)>>
What is this supposed to do?
ANY(
TOP(
SORT(Master DB[Timestamp], TRUE)
, 1)
)
I only need the Last one or current one.
Try:
<<Start: LIST(
MAXROW(
“Master DB”,
"Timestamp",
[Create Proposal?]
)
)>>
It is help to solve the problem. Thank you
User | Count |
---|---|
39 | |
28 | |
24 | |
23 | |
13 |