Seeking help with a widget script for cell.value

Hello,

I am currently using the following widget script for a pivot using rows (no values or columns) on windows OS:

widget.transformPivot({},
    function(metadata, cell) {
        if (cell.value == 'Resolved') {
            cell.style = {
                backgroundColor: '#90EE90'
            }
        } else if (cell.value == 'Open') {
            cell.style = {
                backgroundColor: '#FF7F7F'
            
            }
        };
    }
);

I need two additional conditions. They are:

When the cell value equals 'In Progress' cell background to equal #FFFFE0
When the cell value equals 'Not Applicable' (a default value when no data has been entered into the relevant field) the cell will be blank or the text will be white to blend the words into the background essentially hiding the words 'Not Applicable'.

Any assistance to decrease the visual clutter for end users would be greatly appreciated.

huffnic

Posted 2 years ago·Last reply 2 years ago

3 comments

DRay

·2 years ago

Hello huffnic,

Thank you for reaching out here. I see that this question hasn't had a response yet, so I am reaching out internally to try and get you and get you an answer.