Hi there I am just looking to see if this is possible ?

I want to make a column such that if you choose a certain value from a choice column then it will give you another lot of values to choose from.


IF ([IncidentType] = "Fire")
  Choice ("False Alarm", "Evacuation", "Confirmed Event") ;
Else If ([IncidentType] = "Security")
  Choice ("Crime", "Alcohol Test", "Other")

Any help would be greatly appreciated.

  • This is not possible using calculated column. This is something like cascading dropdown which you can achieve by customizing your list form. – Ganesh Sanap Nov 12 '19 at 12:34

This is not possible OOTB in SharePoint. You can either do it in PowerApps as shown here. or you can write JSLink on the form or simple javascript as shown here.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.