huffnic
Data Storage
Joined 2 years ago
User Profile
User Widgets
Contributions
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.Solved1.6KViews0likes3Comments