Forum Discussion

Copper Contributor

Oct 19, 2022

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 SharePoi...

Lists

ganeshsanap

MVP

Oct 19, 2022

Tron89

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.

Tron89

Copper Contributor

Oct 19, 2022

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 save

ganeshsanap
MVP
Oct 19, 2022
Tron89 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.
- Tron89
  Copper Contributor
  Oct 19, 2022
  its showing the following
  
  Procurement_x003a_Status was not found on the data object.
  
  Uncaught TypeError: Cannot read properties of undefined
  - ganeshsanap
    MVP
    Oct 19, 2022
    Tron89 Procurement_x003a_Status column is shown or hidden on the list form? It should be shown on the list form to use in conditional formula.
    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.