Re: Microsoft List formula is not working

Hi Imi_Jay 

The issue you're facing with the calculated formula in Microsoft List could be related to the automatic recalculation behavior of the formula. Unlike Excel, which recalculates formulas automatically, Microsoft Lists might require a manual trigger for the formula to update and display the correct result.

When you make edits to a record in Microsoft List, it triggers the recalculation of the formulas, which is why you see the correct result after performing some edits. However, for existing records that haven't been modified, the formula might not update automatically.

To resolve this issue, you can try the following steps:

1. Verify the list settings: Ensure that the "Automatic" recalculation mode is enabled for your list. You can check this by going to the List settings and navigating to the "Advanced settings" section.

2. Manual recalculation: After making changes to your list data, you can manually trigger the recalculation of formulas by using the "Calculate" or "Refresh" option. Look for these options in the toolbar or menu of your Microsoft List application.

3. Check for dependencies: If your formula refers to values from other columns or records, ensure that those dependencies are updated correctly. If any referenced values are not refreshed, it could affect the outcome of your formula.

4. Reevaluate your formula: Review your formula for any potential issues or logical errors. Consider simplifying or restructuring it to ensure optimal performance and accurate results.

If the problem persists despite trying these steps, it might be a limitation or bug in the specific version or implementation of Microsoft List you are using. In that case, reaching out to Microsoft support or the relevant community forums for further assistance would be advisable.

I hope this helps! Let me know if you have any further questions.