1{2 "version": 2,3 "widths": {"A": 16, "B": 10, "C": 8, "D": 7},4 "cells": {5 "A1": {"input":"Task","bold":true},6 "B1": {"input":"Owner","bold":true},7 "C1": {"input":"Hours","bold":true,"align":"right"},8 "D1": {"input":"Done","bold":true,"align":"center"},9 "A2": "Write spec", "B2": "Ann", "C2": "12", "D2": "TRUE",10 "A3": "Build UI", "B3": "Bo", "C3": "40", "D3": "FALSE",11 "A4": "Tests", "B4": "Cy", "C4": "26", "D4": "TRUE",12 "A5": "Docs", "B5": "Dee", "C5": "6", "D5": "FALSE",13 "A6": "Release notes", "B6": "Ann", "C6": "3", "D6": "FALSE",14 "A7": "Launch", "B7": "Bo", "C7": "8", "D7": "FALSE",15 "A8": {"input":"Total","bold":true}, "C8": "=SUM(C2:C7)"16 },17 "conditionalFormats": [18 {"ranges":"A2:A7","condition":"formula","values":["=$D2"],"text":"green","strikethrough":true},19 {"ranges":"C2:C7","scale":[{"type":"min","color":"green"},{"type":"percentile","value":"50","color":"yellow"},{"type":"max","color":"red"}]},20 {"ranges":"C8","condition":"gt","values":["100"],"fill":"magenta","bold":true}21 ],22 "validations": [23 {"ranges":"B2:B7","criteria":"list","items":["Ann","Bo","Cy"],"help":"Pick who does it"},24 {"ranges":"D2:D7","criteria":"checkbox"},25 {"ranges":"C2:C7","criteria":"number","condition":"between","values":["0","80"],"reject":true}26 ]27}