Maxrow date

Celes
Participant II

Hi,

Please help me with this: I want to get the most recent date from my virtual column(Related Remarks) and include it to my email body. I tried several syntax but it didnโ€™t worked. Here are some screenshots of my app.

Related Remarks : on this image, I want to include the date and remarks of 9/23/2020 only

3X_9_1_91bba20029ed3113b9d32b58b232327f89b43bba.png

But everytime Iโ€™ve received an email from my app, it showed the 2 rows. the 9/23/2020 and 9/22/2020.

3X_7_5_7598cf611ceba996391d515124686e1ce08046d4.png

Please see below code of my email body(Workflow):

Project Name: <<[Project Name]>>
Description: <<[Description]>>
Start Date: <<[Start Date]>>
Status: <<[Status]>>
Phase: <<[Phase]>>
Classification: <<[Classification]>>
Platform(s): <<[Platform]>>
Rollout SD: <<[Rollout SD]>>
Rollout SA: <<[Rollout SA]>>
Project Resource: <<[Project Resource]>>
Transition Specialist: <<[Transition Specialist]>>
<<Start: [Related Remarks]>>
Remarks
Date:<<[Date]>>
Remarks :<<[Remarks]>>

<>

0 1 117
1 REPLY 1

Try something likeโ€ฆ<<Start:INDEX(ORDERBY([Related Remarks],[_Rownumber],TRUE),1)>>

Top Labels in this Space