Forum Discussion

Riz_K375's avatar
Riz_K375
Copper Contributor
Jun 26, 2023

Conditional field as per option selected

Hi team, I am not sure if this has been posted before or not. I had a look at the other posts but couldn't find the solution.  I am trying to create a simple Change management tracking in Sharepoin...
SharePoint Online
tdprem's avatar
tdprem
Copper Contributor
Jun 26, 2023

Riz_K375 

 

  • Go to list settings-> Validation Settings.
  • Write in the formula to validate

=IF(Category="Medium",IF([Technical Review By]<>"",TRUE,FALSE),TRUE)

 

 

Kindly mark as answer after reviewing the answer.

-

Thanks,

Prem

https://www.linkedin.com/in/premtd/

Melow28's avatar
Melow28
Copper Contributor
Apr 26, 2024

tdprem  why the formula is having error 

=IF(Budget Shift Needed="Yes",IF([Budget Shift EURO]<>"",TRUE,FALSE),TRUE)

 

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Apr 29, 2024

    Melow28 

     

    You have to wrap the column names in square brackets if there is space in the column display name, like [My Column Name]. Try using formula like: 

     

    =IF([Budget Shift Needed]="Yes",IF(ISBLANK([Budget Shift EURO]),FALSE,TRUE),TRUE)

     

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    • Melow28's avatar
      Melow28
      Copper Contributor
      May 02, 2024

      ganeshsanap I tried above formula it does not work , The a Euro Value should not be required since I selected no

       

      • ganeshsanap's avatar
        ganeshsanap
        MVP
        May 02, 2024

        Melow28 

        1. Open settings of "Euro Value" column
        2. Make it non-mandatory like: 

        Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources