I am using SharePoint 2013.
Would you please give me a direction through which way I can accomplish this ?
I have a list where I have a date field (let it be
FinishedDate) with different dates.
Depending on a date I would like to give them a status/or colorize a row
but it should comparing with others
FinishedDates from other rows.
- ID: 1; FinishedDate: 2019/06/08/August;
- ID: 2; FinishedDate: 2019/06/02/February;
- ID: 3; FinishedDate: 2020/02/02/February;
For ID:2; it should be giving color green or status 'Done'.
For ID:1; it should be giving color grey or status 'SoonToDo'.
For ID:3; it should be giving color brown or status 'UhaveTime'.