Forum Discussion
Solved
Error message Calculating Formulas in the List app in Microsoft Teams
I have created a list from Excel, and I am trying to calculate the date difference in a column, I was able to create the formula in excel, however when I created the list in Teams, my formula no long...
- Hi,
You might want to look at Calculated columns and reference something like https://support.microsoft.com/en-gb/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3
Whilst the create list from Excel can be a nice option, not everything is guaranteed to work on the other side.
So as you are now essentially in the world of SharePoint, I would look to how you would achieve what you need in a SharePoint fashion.
Thanks
Henry
Hi,
You might want to look at Calculated columns and reference something like https://support.microsoft.com/en-gb/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3
Whilst the create list from Excel can be a nice option, not everything is guaranteed to work on the other side.
So as you are now essentially in the world of SharePoint, I would look to how you would achieve what you need in a SharePoint fashion.
Thanks
Henry
You might want to look at Calculated columns and reference something like https://support.microsoft.com/en-gb/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3
Whilst the create list from Excel can be a nice option, not everything is guaranteed to work on the other side.
So as you are now essentially in the world of SharePoint, I would look to how you would achieve what you need in a SharePoint fashion.
Thanks
Henry
I tried the formula from that site and it didn't work.