Share via

Help needed with Lists calculated column

Anonymous
2024-11-29T15:15:57+00:00

I am trying to add a calculated column in Microsoft Lists that follows this logic:

  • If the value in Column A is equal to "Yes," the calculated column should take the value from Column B and subtract 16 from it.
  • If the value in Column A is not "Yes," the calculated column should remain empty.

The formula I have attempted to use is:

plaintextCode kopiëren=IF([Column A]="Yes", [Column B] - 16, "")

Here:

  • Column A: A column of type Choice or Text, where the value "Yes" can occur.
  • Column B: A column of type Number.
  • The formula is being added as a calculated column.

Issue:
The formula does not seem to work as expected. Even when the value in Column A is "Yes," the calculated column remains empty.

Questions:

  1. Is the above formula supported in Microsoft Lists?
  2. Are there limitations in Microsoft Lists for using this logic or syntax in calculated columns?
  3. Is there a specific reason why this formula might not work (e.g., type settings or handling empty values)?

I would appreciate your guidance on how to correct or adjust this formula to achieve the desired result.

Microsoft Teams | Microsoft Teams for business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-11-29T17:28:04+00:00

    Dear respected Linda Jelsma,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    I’m sorry you’re having a problem but based on your description we can work together to resolve it.

    For the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

    As per your description, yes, the formula you provided is supported in Microsoft Lists.

    If Column A is a Choice field, the comparison might not work as expected if the choice includes spaces or is case-sensitive. Double-check that the value "Yes" matches exactly.

    I tried in another way:

    =IF(AND([Column A]="Yes", ISNUMBER([Column B])), [Column B] - 16, "")

    If you need to use a comma (,) as a separator in your SharePoint calculated column formula instead of a semicolon (). In some regional settings, SharePoint uses a semicolon (;) as a delimiter for arguments in formulas.

    Since you have the error in your list, I also suspect the problem is related to the language of the SharePoint site, the site collection administrator can check the original language of the site, and you can also check if the SharePoint multilingual feature is enabled? If yes, turn it off. Create multilingual SharePoint sites, pages, and news - Microsoft Support

    In the meantime, could you please test in another SharePoint listing and check the result with us, please understand that it will help us to narrow down your problem.

    Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

    I'm sorry and I apologize for that.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Waqas Muhammad

    0 comments