Filter last data and send as excel attachment

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…

image

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

1 Like