I don't know any JSON at all, I work at an IT help desk and am trying to do a little advanced conditional formatting for our SharePoint list, which contains a user database of sorts.
We're currently going through and filling in the host name for all of the computers on our network in a single line text type column called "Computer Name."
To help the team keep track of which ones have been done, I need simple statement that would check
- If the field in "Computer Name" column is blank, and if it is, then turn the background red.
- If field in "Computer Name" is not blank (a.k.a a value is entered), turn the background green.
I found some code online that worked sort of in that if text was added to an empty cell it turned it green, but if that text was then removed, the cell remained green. I also could not seem to get the if blank, make the bg red part working at all.
If text is added to the cell - turn background green
If text is removed from the cell so that the cell is empty, change it to red.