Forum Discussion

ZayneMolskow's avatar
ZayneMolskow
Copper Contributor
May 28, 2024
Solved

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 ...
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
Silver 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
      Silver 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)

      • ZayneMolskow's avatar
        ZayneMolskow
        Copper Contributor
        May 29, 2024
        Got it working now, thank you so much!