Forum Discussion

Brass Contributor

Jul 18, 2023

Microsoft List formula is not working

Hi all, I am encountering a problem in a calculated formula in the Microsoft List. Scenario- Based on different values in different columns , I need a record to appear as "Overdue" Formula u...

Brass Contributor

Aug 18, 2023

SvenSieverding
Thanks! Logic is correct. For some reason it's showing Overdue for all the scenarios. Could that be the way column name like [Date - resubmission passed ] should be written in the JSON code differently? That's the only issue I can think of. Appreciate if you can look into this.

Thanks,
Imalka Jayalath

ganeshsanap

MVP

Aug 18, 2023

Imi_Jay In SharePoint JSON formatting, you have to use the internal names of columns in format like [$InternalNameOfColumn] and not the display names of columns. So, try using internal names for all your columns which are referenced in the JSON.

You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.