I'm a bit of a noob about JSON and I want to use it to my benefit. What I want to do based on the attachment is the following:
Latin Qual Required? column is set to Choice setting and Latin Qual Date column is set to Short Date setting
- If Latin Qual Required? column has "Yes" and the Latin Qual Date is empty, change cell to background color with a specific hex code or the "error" class with Icon.
- If Latin Qual Required? column has "Yes" and the Latin Qual Date is entered, change cell to background color with a specific hex code "success" class with Icon.
- If Latin Qual Required? column has "Yes" and the Latin Qual Date is empty, change cell to red or the "error" class with Icon.
- If Latin Qual Required? column has "No" a change cell to background color with a specific hex code