Forum Discussion

Bd2023-b's avatar
Bd2023-b
Brass Contributor
Aug 29, 2023
Solved

Sharepoint list issue - Enter valid condition

Hi , I have 2 list column  - Mark% and Grade .  If Mark % > =60 % - Grade A , Mark % > 31%  - 59% - Grade B , Mark % - 0 % to 30% - Grade C. I tried but getting error - Enter a valid condition I put ...
2010
Document Library
files
microsoft lists
mobile
powershell
SharePoint Online
sharepoint server
  • ganeshsanap's avatar
    ganeshsanap
    Aug 30, 2023

    Bd2023-bYou cannot refer another column in "default value" formula for any column in column settings.

     

    So, you will have to create calculated column for "Grade".

     

    Assuming Mark % column is of type "Number", you can use formula for Grade column like below: 

     

    =IF([Mark %]>=60,"Grade A",IF([Mark %]>30,"Grade B","Grade C"))

     

    OR 

     

    =IF([Mark %]>=60,"Grade A",IF([Mark %]>30,"Grade B",IF([Mark %]>=0,"Grade C","")))

     

    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.

ganeshsanap's avatar
ganeshsanap
MVP
Aug 30, 2023

Bd2023-bYou cannot refer another column in "default value" formula for any column in column settings.

 

So, you will have to create calculated column for "Grade".

 

Assuming Mark % column is of type "Number", you can use formula for Grade column like below: 

 

=IF([Mark %]>=60,"Grade A",IF([Mark %]>30,"Grade B","Grade C"))

 

OR 

 

=IF([Mark %]>=60,"Grade A",IF([Mark %]>30,"Grade B",IF([Mark %]>=0,"Grade C","")))

 

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