Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

overdue dates indicator color coding

 
Hi Experts, 

 

I would like to create indicator icons to the below 'Meeting Schedule Deadline Status' column.

 

The conditions would be:

●= date < today

●= date > today

Meeting Schedule DeadlineMeeting Schedule Deadline Status
6/5/2021●
7/19/2021●
7/5/2021●

 

Could you please advise what would be the simpliest way to write code for this? Thanks so much for your help!

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous,

    Did you mean to create a column with different icons based on current date values?
    If that is the case, you can create a calculated column with the if statement and use Unicode characters to show these special icons.
    Regards,

    Xiaoxin Sheng

2 Replies