Forum Discussion

ZayneMolskow's avatar
ZayneMolskow
Copper Contributor
May 28, 2024

Calculated Column based on answer from another field

Hello, 

I am trying to create a enable/disable user account list/workflow. This list is tied to a workflow that sends an email out and that email is read by our TrackIT system and then put into a specific queue based on the title. So the title needs to be a specific thing. I'm trying to create a calculated column that equals a specific text, based on the response to another field. Basically, if the user selects "Create New Account" or "Disable New Account" I want the Calculated field text to be either A or B (just for this example). 

Does anyone know how I could formulate this? I've been trying to do it on my own, but its quite difficult. I'm not sure where I'm going wrong. 

Thanks, 
Zayne

Lists
Microsoft Lists
  • Rob_Elliott's avatar
    Rob_Elliott
    May 28, 2024

    ZayneMolskow your calculated column just needs to be:

    =IF(Requirement="Create New Account","A",IF(Requirement="Disable New Account","B",""))

     

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    May 28, 2024

    ZayneMolskow your calculated column just needs to be:

    =IF(Requirement="Create New Account","A",IF(Requirement="Disable New Account","B",""))

     

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

    • ZayneMolskow's avatar
      ZayneMolskow
      Copper Contributor
      May 29, 2024
      Thank you so much! This is a big help!

      If you don't mind, when I try to create the calculated column, this error comes up. Do you know what the issue could be? It only happens when I try to create the column, and mentions SharePoint Foundations. Perhaps a security issue?

      "Sorry, something went wrong
      The security validation for this page has timed out. Click Back in your Web browser, refresh the page, and try your operation again.
      TECHNICAL DETAILS



      Troubleshoot issues with Microsoft SharePoint Foundation.
      Correlation ID: 142f2da1-90a4-5000-9789-5dd1d119b570

      Date and Time: 5/28/2024 12:54:11 PM"
      • Rob_Elliott's avatar
        Rob_Elliott
        Bronze Contributor
        May 29, 2024

        ZayneMolskow I've only occasionally had this. I think it just means the SharePoint page/list has been open too long. Shut the site down and re-load.

         

        Rob
        Los Gallardos
        Microsoft Power Automate Community Super User.
        Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources