question

FosterChristopherCHRC-2920 avatar image
0 Votes"
FosterChristopherCHRC-2920 asked SharonZhao-MSFT commented

Why isn't my "age" column updating when I open my list?

So I have created a list for Service Recovery with a goal of responding is within 168 hours, I have used ()Now to set the date for the column using this formula =(NOW()-[Date reported])/24 and it works fine when I create the new record, but when I return the next day to refresh the list it is still saying it is on day 1, it is not until I go into the record and hit the save button that it actually refreshes with the new hours

office-teams-windows-itpro
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@FosterChristopherCHRC-2920,

Do you use Microsoft Teams to create the list for Service Recovery?

Office-teams-windows-itpro tag is for Microsoft Teams. Your question seems not related to Teams. If I misunderstand your words, please give us more details to understand your situation. Thanks for your understanding.

0 Votes 0 ·

You are correct, I used MS Teams to create my list and I reference another column for the date in which the case was opened and I want the age column to calculate the hours the case is open. It preforms as requested however it does not update unless I go into the record and save it again.

0 Votes 0 ·

1 Answer

SharonZhao-MSFT avatar image
0 Votes"
SharonZhao-MSFT answered SharonZhao-MSFT commented

@FosterChristopherCHRC-2920,

Thanks for your explanation. It seems that you add an excel in Teams.

You could open this excel file in desktop app. Then, check Calculation options of Formulas as below. It should be set as Automatic.
100532-image.png


If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



image.png (14.6 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

No I used a excl formula in the calculate column field but it is in a teams list. I need help with a list formula to get this column to calculate properly.

0 Votes 0 ·
SharonZhao-MSFT avatar image SharonZhao-MSFT FosterChristopherCHRC-2920 ·

@FosterChristopherCHRC-2920,

This is by design as well as desktop Excel app.

The following 3 events will trigger the Now() function to refresh:

  • Any cell in the worksheet is changed

  • A new number or formula is entered in any cell

  • F9 is pressed


0 Votes 0 ·

f9 is not working in the list environment. Is there any other formula to get it to update when the list is opened? This is I would like to happen on open

0 Votes 0 ·
SharonZhao-MSFT avatar image SharonZhao-MSFT FosterChristopherCHRC-2920 ·

@FosterChristopherCHRC-2920,

I find that you mention list many times. What does it mean?

I add Excel app in Teams and test in the excel file. F9 works well.

If I misunderstand you, please give us more information or screenshots. Thanks for your understanding.

0 Votes 0 ·
SharonZhao-MSFT avatar image SharonZhao-MSFT FosterChristopherCHRC-2920 ·

@FosterChristopherCHRC-2920,
Do you have any update now?
Please feel free to drop us any notes.
Have a nice day!

0 Votes 0 ·
SharonZhao-MSFT avatar image SharonZhao-MSFT FosterChristopherCHRC-2920 ·

@FosterChristopherCHRC-2920,
If you have any questions or needed further help on this issue, please feel free to post back.

0 Votes 0 ·