SharePoint calculated column not updating automatically

Rob_Elliott 

Thanks for the reply.

I'm completely new to JSON. May I know how JSON can help with dynamic updates?
I thought the scripting will only affect the formatting (ie visual output) of the column but it may not have an impact on the behavior of the formulas in the calculated column?

Sorry for asking these because I was trying to construct a "helper" column in my SharePoint library that is capable to update dynamically in order to help me to sort my folders (named in the format of MMMYYYY) in chronological order, so I intended to use "IF" conditions to assign a month index to the folders that will help me to sort the folders in my desired order (instead of the default ascending/ descending order).

Please feel free to point out my misconceptions and propose any alternative solutions/ examples on JSON scripting that can achieve a similar result of the "IF" function.