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
But everytime Iโve received an email from my app, it showed the 2 rows. the 9/23/2020 and 9/22/2020.
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]>>
<>
Try something likeโฆ<<Start:INDEX(ORDERBY([Related Remarks],[_Rownumber],TRUE),1)>>
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |