Using SharePoint 2010.
Currently I have a column that is calculating the "Days left to respond" using the formula below.
This is working fine in terms of the calculations, however, I need a method to update the calculated values in this column. I know that the calculated fields are updated at the save time and not at render time from digging around.
I am ok with manually refreshing the data as long as it is something that can be done quickly (as in not 1 item at a time). If there was a select all option and then a mass edit/save, that would work.
Does anyone have any suggestions? I would like to avoid a lot of complications as I am not in IT and I am limited due to security protocols on even my own laptop.