Forum Discussion
Conditional Formula - List Form
Hi all,
I am after a bit of help if possible.
I want to add the following conditional formula =if([$Procurement_x003a_Status] == 'Approved', 'true', 'false') to a yes/no column in my SharePoint List Form, but for some reason it is not allowing me to save the formula. This conditional formula is being used on my choice columns without any problems.
Does anyone have any ideas on this?
This is a n example of a choice column where it works
This is an example of the Yes/No column that is not allowing me to save the same formula.
7 Replies
Tron89 Syntax of your formula looks good as per the Microsoft official documentation: Show or hide columns in a list or library form
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.
- What is the column/data type of "Procurement_x003a_Status" column?
- Are you getting any error while saving?
Can you hard refresh (Ctrl + F5) and/or clearing browser cache/cookies and try applying conditional formula again.
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.
- Thanks for the reply Procurement_x003a_Status is a choice column (not multiple selection). I've cleared the cashe and tried on another browser, but still no joy.
I dont get and error, it just wont allow me to saveTron89 Can you check if there is any error in browser developer console?
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.
