Share via

Adding color in column validation

Anonymous
2020-05-06T19:59:43+00:00

I've created a custom list in SharePoint online to track our department training. I have a date and time column titled "Expiration" that will list the date that the training/certification will expire. I would like to add a formula to this column that will turn orange once it's 30 days from expiration and then turn red once it's 7 days from expiration. I've searched online and I haven't found a formula that quite matches what I'm looking to do.

Thank you.

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2020-05-07T08:15:51+00:00

Hi Linda,

After testing, I'm afraid there doesn't have an out of box way to achieve your requirement in the existing user interface in SharePoint Online yet. But I think you may post a new question in the SharePoint Developer Forum or Stack Overflow to ask for a piece of JSON code and use the design mode to format the column through the JSON code.

References:

Column formatting

Use column formatting to customize SharePoint

Support and feedback

I'm willing to help you but I know little about the code as this is beyond our support scope. Sorry for the inconvenience of posting new threads in other forums. Hoping you can find the answer soon.

We appreciate your understanding.

Best Regards,

Hugo

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest