syhussaini
New Member
Hello Team,
I am writing to seek your help in building a new column on my List which should set values dynamically i.e. based on the date value of the other column in the list.
I have an Expiry Date Field and now I would like to show another column in the list where if the date is less than today the cell value should be set to Expired and if it is greater than or equal to today it should set to Active.
Currently I am filtering out the expired items, however, I would like to show them but with the respective status.
I would also like to achieve a way color the rows that have the status "Expired".
Can someone please guide me.
PS: I am a newbie with a fast learning ability, kindly consider adding steps and I will certainly follow.
Looking forward to hearing soon.
Best Regards,
Syed H
I am writing to seek your help in building a new column on my List which should set values dynamically i.e. based on the date value of the other column in the list.
I have an Expiry Date Field and now I would like to show another column in the list where if the date is less than today the cell value should be set to Expired and if it is greater than or equal to today it should set to Active.
Currently I am filtering out the expired items, however, I would like to show them but with the respective status.
I would also like to achieve a way color the rows that have the status "Expired".
Can someone please guide me.
PS: I am a newbie with a fast learning ability, kindly consider adding steps and I will certainly follow.
Looking forward to hearing soon.
Best Regards,
Syed H