Forum Discussion
Calculated Column based on answer from another field
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 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)
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"
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)- Got it working now, thank you so much!