SharePoint list not updating

Question

There is a list on SharePoint that I am working on where the "Days Since Submitted" field is updating correctly from when the items have been created.

I checked the list settings and found the column had this formula, which looks correct:

=DATEVALUE(TEXT(NOW(),"mm/dd/yyyy"))-DATEVALUE(TEXT(Created,"mm/dd/yyyy"))

I also compared and contrasted another SharePoint list that hasn't had these issues and the coding is exactly the same.

I checked the dates these items have been created and they are all showing as "0" days since submitted.

Is there a bug with the system? Or is there something that could be causing the field to not update?

Here are screenshots below:

Please let me know if there are any other questions, comments or concerns.

Answer 1

Hi Ivan,

I tried your formula and I saw the correct result in both my lists, here’s a screenshot for your reference.

Though it shouldn’t matter but just for the test purpose, could you please switch your affected list experience from classic to modern? There are some instances where we got feedback from customers saying some functions are not working in classic view but switching to modern works and some said, it works in classic but not in modern, I just wanted to check if this is the scenario in your case.

To use the modern experience just for yourself, select Exit classic experience in the bottom, left corner of the page. To return, select Return to classic SharePoint.

Please Note, Exit classic experience option is not available if default experience is set to Classic experience.

The formula you are using is correct, please check the Column settings to confirm if you have selected Single line of Text as a data type and whether you have applied any formatting or not.

Besides, please try re-creating the same column with the same formula in the affected list and see if shows the correct result.

Let me know the status.

Regards,

Neha

Answer 2

Hi Ivan,

Did you check the above reply? If you still need help, please update us.

Regards,

Neha

Answer 3

Hi Neha,

Sorry for the late response. I did try switching from classic to modern with no difference made.

Let me check again on column settings.

Answer 4

Hi Neha,

Okay, I changed the data type returned to "Single line of text" as opposed to "Number."

This has fixed the issue.

Thank you very much for your assistance!

This can now be marked as Resolved.

Answer 5

Hi,

So we have tried this method and while it works for a temporary amount of time, eventually it will stop working again.

After a while, "Days Submitted" field will contain "#Name?" instead of the actual number of days submitted since.

Changing the data type to Number then back to Single line of text would work but this still does not solve the issue.

We don't want to just keep on changing the data types to make sure the number appears again.

Here is how it looks like after we applied the changes.