Hello,
I have 3 columns - [Date 1], [Date 2] & [Date 3].
I also would like to create a Virtual Column [Min Date] as below:
Date 1 | Date 2 | Date 3 | Min Date |
20/5/2020 | 21/5/2020 | 22/5/2020 | 20/5/2020 |
25/5/2020 | 24/5/2020 | 23/5/2020 | 23/5/2020 |
25/5/2020 | 24/5/2020 | 26/5/2020 | 24/5/2020 |
I wrote in app formula to Virtual column: min([Date 1], [Date 2], [Date 3])
However It returns error: MIN function is used incorrectly
How can I rewrite the formula to get the minimun date from those 3 Date columns? Thank you.
@Steve @Joseph_Seddik @Marc_Dillon @Suvrutt_Gurjar @Rafael_ANEIC-PY
Solved! Go to Solution.
Hello @LawrenceMa, try this
MIN(LIST([Date 1], [Date 2], [Date 3]))
Try this.
min(List([Date 1], [Date 2], [Date 3]))
Hello @LawrenceMa, try this
MIN(LIST([Date 1], [Date 2], [Date 3]))
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |