Spreadsheet: 885563d1735264928-conditional-format-entire-row-based-on-user-input-devices-and-rules
Sheet: Sheet1

 | Conditions Outside
10 Minute Clock Timer | $ClockVarable10
15 Minute Clock Timer | $ClockVariable15
20 Minute Clock Timer | $ClockVariable20
60 Minute Clock Timer | $ClockVariable60
[COOP] Coop Closed at Sunset | Pop Door | Pushover
[COOP] Coop Egg Freeze Warning | Coop Conditions Inside | $EggFreezeWarning | Pushover
[COOP] Coop Entry Door Open | Chicken Coop Entry Door | Pushover
[COOP] Coop fan OFF Temperature | Coop Conditions Inside | $ClockVariable20 | V Fan Lock | Chicken Coop Fan
[COOP] Coop fan ON Temperature | Coop Conditions Inside | $ClockVariable20 | $CoopConditionsInside | $TemperatureDifferenceCoop | Chicken Coop Windows | V Fan Lock | Chicken Coop Fan
[COOP] Coop Light OFF at 8:30 AM | Chicken Coop Light
[COOP] Coop Light ON at Sunrise Every Day | Chicken Coop Light
[COOP] Coop Open Every Morning | V Lock Pop Door | Conditions Outside | $HighTempToday | $LowTempToday | Pop Door | Pushover
[COOP] Coop Pop Door Closes During the Day | [NAME] Pop Door | $AfterSunrise | Pushover
[COOP] Coop Pop Door Opens During the Night | [NAME] Pop Door | $AfterSunrise
[COOP] Coop Pop Door Safety Check | [NAME] Pop Door | Pushover
[COOP] Coop Power OFF Notification | Power Sensor Coop | V Coop Power Off Acknowledge | $AfterSunrise | Pushover | Coop Power Off Outlet
[COOP] Coop Power ON Notification | Power Sensor Coop | $AfterSunrise | Pushover
[COOP] Coop Windows Close Under 41* | Coop Conditions Inside | 45 Minute Timer | V Coop Window Lock | Chicken Coop Windows
[COOP] Coop Windows Open Over 42* | Coop Conditions Inside | 60 Minute Timer | V Coop Window Lock | Chicken Coop Windows
[COOP] HEAT OFF | Coop Conditions Inside | $ClockVariable60 | Coop Heat
[COOP] Heat ON | Coop Conditions Inside | $ClockVarable10 | Pop Door | Chicken Coop Windows | Coop Heat
[COOP] Inside Water Heater | Coop Conditions Inside | Water Heater Inside
[COOP] Temperature History | Coop Conditions Inside | $ZCoopHistory3 | $ZCoopHistory2 | $ZCoopHistory1 | $ZCoopCurrent | $ZCoopHistoryTime3 | $[NAME] | $ZCoopHistoryTime1 | $ZCoopHistoryTimeCurrent
[COOP] Vent ON based on humidity level | Coop Conditions Inside | 60 Minute Timer | $HumidityDifferenceCoop | Chicken Coop Vent
[COOP] Water Base Outside ON/OFF | Conditions Outside | $ClockVariable60 | [NAME]
[EMERGENCY] Fire Alarm | [NAME] | Pushover | Basement Lights | Basement Lights Stay ON | Breakfast Nook Fan | Breakfast Nook Light | Chandelier | [NAME] | Covered [NAME] | [NAME] | [NAME] | Front Porch Lights | Garage Door 1 | Garage Light Keep ON | Garage Lights | Great Room Lamp | [NAME] | Kailey's Ceiling Lights | Kailey's Fan Switch | [NAME] | [NAME] | Master [NAME] | Master [NAME] | Master [NAME]
[GARAGE] Garage Door 1 Open 10 minutes | $GarageDoorJulie | V Presence Switch | Pushover
[GARAGE] Garage Door 2 Open 10 minutes | $GarageDoorKevin | V Presence Switch | Pushover
[GARAGE] Garage Door Open Notice | $[NAME] | $GarageDoorStateKevin | Pushover
[GARAGE] Garage Door Opens Late | $[NAME] | $GarageDoorStateKevin | Pushover
[GARAGE] Julie Garage Door Reset | [NAME]
[GARAGE] [NAME] | [NAME]
[GARAGE] Voice Garage Doors ON/OFF | V Voice Garage Door Switch | Garage Door 1 | Garage Door 2
[GREAT ROOM] Great Room Lamp OFF at Sunrise | Great Room Lamp
[GREAT ROOM] Great room lamp ON Sunset | $SixtyMinuteTimer | V Presence Switch | Great Room Lamp
[GREENHOUSE] Greenhouse 1 Fan ON/OFF | Greenhouse 1 Temperature | Greenhouse 1 Fan
[GREENHOUSE] Greenhouse 1 Feed Schedule | Greenhouse 2 Heat | Greenhouse 1 Pump
[GREENHOUSE] Greenhouse 1 Vents Open/Closed | Greenhouse 1 Temperature | V Vent Lock | Greenhouse Vents
[GREENHOUSE] Greenhouse 1R Feed Schedule | Greenhouse 2 Heat | Pump 1 R
[GREENHOUSE] Greenhouse 2 Fan ON/OFF | $[NAME] | $ClockVariable15 | Greenhouse 2 Temp-Humidity | Intake Air | Green House Fan
[GREENHOUSE] Greenhouse 2 Feed Schedule | Greenhouse 2 Heat | Greenhouse 2 Pump
[Greenhouse] Greenhouse Heat On/Off | Greenhouse 1 Temperature | Greenhouse 1 Fan
[GREENHOUSE] Grow Light OFF | Grow Light
[GREENHOUSE] Grow Light ON | Grow Light
[HVAC] Attic Fan OFF Temperature/Humidity | $ClockVariable15 | Attic Temp-Humidity | Attic Fan
[HVAC] Attic Fan ON At 9:00 PM | $TemperatureDifferenceAttic | Attic Fan
[HVAC] Attic Fan ON Humidity | Attic Temp-Humidity | $ClockVariable15 | $HumidityDifference | Attic Fan
[HVAC] Attic Fan ON Temperature | Attic Temp-Humidity | $ClockVariable15 | $TemperatureDifferenceAttic | Attic Fan
[HVAC] Blower (Large) off less than 69* | My ecobee | Wood Burner Fan Lock | Blower
[HVAC] Blower Cycle Part 1 | $ClockVariable20 | V Fan Switch | Blower
[HVAC] Blower Cycle Part 2 | Blower
[HVAC] Breakfast Nook Fan OFF less than 70* | My ecobee | Breakfast Nook Fan
[HVAC] Breakfast Nook Fan ON 70 - 74 | My ecobee | Breakfast Nook Fan
[HVAC] Breakfast Nook Fan ON 74.1 - 76 | My ecobee | Breakfast Nook Fan
[HVAC] Breakfast Nook Fan ON 76.1 - 78 | My ecobee | Breakfast Nook Fan
[HVAC] Breakfast Nook Fan Speed at 78.1* | My ecobee | Breakfast Nook Fan
[HVAC] Cooling Set Point 73* | My ecobee
[HVAC] Cooling set point 73* anyone home | V Presence Switch | $ClockVariable15 | My ecobee | V Seasonal Switch
[HVAC] Cooling set point 77* everyone leaves home | [NAME] | My ecobee | Seasonal Switch
[HVAC] [NAME] less than 73* | My ecobee | Pushover
[HVAC] FAN SWITCH is off, all blowers off | V Fan Switch | Blower | Wood Burner Fan | V Fan Switch
[HVAC] Fan Switch OFF 69 | My ecobee | V Fan Switch
[HVAC] Fan Switch OFF 73 | $[NAME] | Wood Burner Fan | V Fan Switch
[HVAC] Fan Switch ON 72* | $[NAME] | V Winter Mode | V Fan Switch
[HVAC] Furnace Fan Auto At 79* | My ecobee
[HVAC] Furnace Fan ON every 60 minutes | $ClockVariable60 | $Month | My ecobee
[HVAC] Heating Set Point 62* If [NAME] Is OFF | V Presence Switch | V Winter Mode | V Presence Switch | V Seasonal Switch | My ecobee
[HVAC] Heating Set Point 68* Anyone Home | [NAME] | My ecobee | V Seasonal Switch | V Presence Switch
[HVAC] Josh's Window Open AC Is ON | [NAME] | My ecobee | Pushover
[HVAC] Kailey's Window Open - 69 in House | My ecobee | Kailey's Window | Pushover
[HVAC] Kailey's Window Open AC Is ON | Kailey's Window | My ecobee | Pushover
[HVAC] Master [NAME] | Master Bath Humidity | $BathroomHumidityDifference | $ClockVariable20 | $BathroomHumidityDifference | Master [NAME]
[HVAC] Master Bath Fan ON | Master Bath Humidity | Master [NAME]
[HVAC] Master Bedroom Fan Schedule | $ClockVariable20 | Master [NAME]
[HVAC] Pause Blowers ON | V Pause Blowers | Blower | Wood Burner Fan | V Fan Switch
[HVAC] Seasonal Switch Changes To OFF | V Seasonal Switch | Pushover
[HVAC] Seasonal Switch Is ON | V Seasonal Switch | My ecobee | Pushover
[HVAC] Winter Mode Is ON | V Winter Mode | V Seasonal Switch | My ecobee | Pushover
[HVAC] Wood Burner Fan ON | V Fan Switch | Wood Burner Fan
[LIGHTING] Basement Lights OFF | Basement Lights | $ClockVarable10 | $[NAME] | V Basement Lights Lock
[LIGHTING] Basement Lights ON | Basement Motion 1 | Basement Door | Steps Motion | Basement Stairway Lights | V Massage Switch | V Presence Switch | Basement Lights
[LIGHTING] Basement Stairway Lights OFF | $BasementStairwayLights | Basement Stairway Lights
[LIGHTING] Basement Stairway Lights ON | Steps Motion | Upstairs basement door | V Massage Switch | V Presence Switch | Basement Stairway Lights
[LIGHTING] Counter Lights ON | Julie - presence | Julie's S22+ - presence | [NAME]
[LIGHTING] Evening Lighting Levels | [NAME] | Breakfast Nook Light | Chandelier | Great Room Lamp | [NAME]
[LIGHTING] Evening lighting levels presence after sunset | V Presence Switch | $AfterSunrise | Home to execute Scene: Evening Light Levels
[LIGHTING] Front Porch Lights OFF During the Day | Front Porch Lights | $FiveMinuteTimer
[LIGHTING] Front Porch Lights OFF Midnight | Front Porch Lights
[LIGHTING] Front Porch Lights ON at Sunset | Front Porch Lights
[LIGHTING] Front Porch Lights ON Morning | Front Porch Lights
[LIGHTING] Garage Lights OFF | $GarageLightsOn | $GarageLightLock | Garage Lights
[LIGHTING] Garage Lights ON | Basement Door | Garage Motion 1 | Garage Motion 2 | $[NAME] | $GarageDoorStateKevin | Garage Lights
[LIGHTING] Good Night | V Good Night | Basement Lights | Breakfast Nook Light | Chandelier | [NAME] | Covered [NAME] | [NAME] | [NAME] | Garage Lights | Great Room Lamp | V Holiday Decorations | Holiday Mantle | Holiday Railing | Holiday Tree | [NAME] | Master [NAME] | Master [NAME]
[LIGHTING] Good Night OFF 6:00 AM | V Good Night | [NAME]
[LIGHTING] Holiday Front Porch Lights OFF AM | Holiday Front Porch
[LIGHTING] Holiday Front Porch Lights ON AM | Holiday Front Porch
[LIGHTING] Holiday Front Porch Lights ON/OFF PM | Holiday Front Porch
[LIGHTING] Holiday Light List | V Holiday Decorations | V Holiday Decorations | Holiday Mantle | Holiday Tree | Holiday Railing | [NAME]
[LIGHTING] Holiday Lights ON 7:00 AM or With Presence ON | V Presence Switch | V Holiday Decorations
[LIGHTING] House Floods Normal Motion | House Flood Lights
[LIGHTING] House Floods Stay ON | House Flood Lights
[LIGHTING] Keep OFF with no presence | Basement Lights | Basement Stairway Lights | Breakfast Nook Light | Chandelier | [NAME] | Covered [NAME] | [NAME] | [NAME] | Holiday Mantle | Holiday Railing | Holiday Tree | [NAME] | [NAME] | [NAME] | Master Bath Mirror Lights | Master [NAME] | V Presence Switch | V Holiday Decorations
[LIGHTING] Master Bedroom Light Settings | Master [NAME]
[NOTICE] Basement Door Open 5 Minutes | $BasementDoorOpen | Pushover
[NOTICE] Basement Light ON Notice | $BasementLightsON | V Basement Lights Lock | Pushover
[NOTICE] GarageLights ON Notice | $GarageLightsOn | V Garage Light Lock | Pushover
[POOL] Pool OFF Notification (April, May, September, October) | Pool System | [NAME] | $Month | Pushover
[POOL] Pool Power Status | $PoolPower | Pushover
[POOL] Pool System Off Spring/Fall | $Month | V Pool Lock | [NAME] | Pushover | $PoolStatus
[POOL] Pool System Off Summer | $Month | V Pool Lock | [NAME] | Pushover | $PoolStatus
[POOL] Pool System ON | V Pool Lock | [NAME] | Pushover | $PoolStatus
[PRESENCE] All Lights Off Everyone Gone | V Presence Switch | [NAME] | Basement Lights | Breakfast Nook Light | Chandelier | [NAME] | Covered [NAME] | [NAME] | [NAME] | Garage Lights | V Holiday Decorations | Holiday Mantle | Holiday Railing | Holiday Tree | [NAME] | [NAME] | Master Bath Mirror Lights | Master [NAME]
[PRESENCE] Guest Switch ON | [NAME] | V Presence Switch
[PRESENCE] Julie Arrived | V Julie Presence | $[NAME] | [NAME] | Pushover
[PRESENCE] [NAME] | V Kevin Presence | $[NAME] | Pushover
[PRESENCE] Presence Switch OFF if Everyone Gone | [NAME] | $ClockVarable10 | V Kevin Presence | V Julie Presence | $[NAME] | $[NAME] | V Presence Switch
[PRESENCE] Presence Switch ON If Anyone Home | V Julie Presence | V Kevin Presence | $ClockVarable10 | $[NAME] | $[NAME] | V Presence Switch | [NAME]
[V] Basement Light Motion Active {variable} | Basement Motion 1 | $[NAME]
[V] Basement Light Motion Inactive {variable} | Basement Motion 1 | $[NAME]
[V] Coop Door Status | Chicken Coop Entry Door | $[NAME]
[V] Coop Fan Status | Chicken Coop Fan | $FanStatus
[V] Coop Light Status | Chicken Coop Light | $CoopLightIs
[V] Coop Pop Door Status | [NAME] Pop Door | $PopDoorStatus
[V] Coop Power Status | Power Sensor Coop | $CoopPowerIs
[V] Coop Window Status | Chicken Coop Windows | Chicken coop windows lock | $CoopWindowStatus
[V] Coop Window Status Locked | Chicken Coop Windows | Chicken coop windows lock | $CoopWindowStatus
[V] Egg Freeze Warning | Chicken Coop Entry Door | $EggFreezeWarning
[V] Josh Presence | iPhone | $JoshIsPresent
[V] Pool Status | Pool System | Pool Lock | $PoolStatus
[V] Set Basement Door CLOSED Variable to FALSE | Basement Door | $BasementDoorOpen
[V] Set Basement door OPEN Variable TRUE | Basement Door | $BasementDoorOpen
[V] Set Basement Lights OFF Variable | Basement Lights | $BasementLightsON
[V] Set Basement Lights ON Variable | Basement Lights | Basement Motion 1 | Steps Motion | Laundry Motion | $BasementLightsON
[V] Set Basement Motion Variable | Basement Motion 1 | Steps Motion | Laundry Motion | $BasementStairwayMotionActive
[V] Set Basement Stairway Lights Variable | Steps Motion | Basement Stairway Lights | $BasementStairwayLights
[V] Set Basement Stairway Motion Variable | Steps Motion | $BasementStairwayMotionActive
[V] Set Day Of Month | $DayOfMonth | https://lab.sharptools.dev/date
[V] Set Ecobee Humidity Variable | My ecobee | $EcobeeHumidity
[V] Set Ecobee Temperature Variable | My ecobee | $EcobeeTemperature
[v] Set Fan Switch ON variable to true | My ecobee | $WoodBurnerFanOnTemperature | $[NAME]
[V] Set Fan Switch Variables +1 | Wood Burner +1 | Wood Burner -1 | $FanSwitchSetPointUpOne | $FanSwitchSetPointDownOne
[V] Set Fan Switch Variables -1 | Wood Burner -1 | Wood Burner +1 | $FanSwitchSetPointUpOne | $FanSwitchSetPointDownOne
[V] Set Garage Door Julie MOVING Status | [NAME] | $GarageDoorJulieStatus
[V] Set Garage Door [NAME] | [NAME] | $GarageDoorKevinStatus
[V] Set Garage Door State Julie | Zooz ZEN17 Universal Relay (s1) | $[NAME]
[V] Set Garage Door State [NAME] | Zooz ZEN17 Universal Relay (s2) | $GarageDoorStateKevin
[V] Set Garage Light Lock Variable FALSE | V Garage Light Lock | $GarageLightLock
[V] Set Garage Light Lock Variable TRUE | V Garage Light Lock | $GarageLightLock
[V] Set Garage Lights Variable FALSE | Garage Lights | $GarageLightsOn
[V] Set Garage Lights Variable TRUE | Garage Lights | Garage Motion 1 | Garage Motion 2 | $GarageDoorStateKevin | $[NAME] | Basement Door | $GarageLightsOn
[V] Set Humidity Difference | Attic Temp-Humidity | Conditions Outside | $ClockVarable10 | $HumidityDifference
[V] Set Humidity Difference in the Coop | Conditions Outside | Coop Conditions Inside | $ClockVarable10 | $HumidityDifferenceCoop
[V] Set Humidity Difference Master Bath | Master Bath Humidity | $MasterBathHumidity | $BathroomHumidityDifference
[V] Set Humidity Variable Attic | Attic Temp-Humidity | $[NAME]
[V] Set Humidity Variable Conditions Inside Humidity | Coop Conditions Inside | $ConditionsInsideHumidity
[V] Set Humidity Variable Conditions Outside | Conditions Outside | $ConditionsOutsideHumidity
[V] Set Humidity Variable Greenhouse 1 | Greenhouse 1 Temperature | $Greenhouse1Humidity
[V] Set Humidity Variable Greenhouse 2 | Greenhouse 2 Temp-Humidity | $GreenHouse2Humidity
[V] Set Julie Presence | Julie's S22+ | $ClockVarable10 | $[NAME] | V Julie Presence
[V] Set [NAME] | [NAME]'s S22+ | $ClockVarable10 | $[NAME] | V Presence Switch
[V] Set Master Bath Humidity Variable | Master Bath Humidity | $MasterBathHumidity
[V] Set Pool Power Variable | Pool Power Status | $PoolPower
[V] Set Sunrise/Sunset Variable FALSE | $AfterSunrise
[V] Set Sunrise/Sunset Variable TRUE | $AfterSunrise
[V] Set Temperature Difference Attic | Attic Temp-Humidity | Conditions Outside | $ClockVarable10 | $TemperatureDifferenceAttic
[V] Set Temperature Difference in the Coop | Coop Conditions Inside | Conditions Outside | $ClockVarable10 | $TemperatureDifferenceCoop
[V] Set Temperature Variable Attic | Attic Temp-Humidity | $AtticTemperature
[V] Set Temperature Variable Attic ROUNDED | Attic Temp-Humidity | $AtticTemperatureRounded
[V] Set Temperature Variable Conditions Inside ROUNDED | Coop Conditions Inside | $CoopInsideTemperatureRounded
[V] Set Temperature Variable Conditions Outside | Conditions Outside | $ConditionsOutside
[V] Set Temperature Variable Coop Conditions Inside | Coop Conditions Inside | $CoopConditionsInside
[V] Set Temperature Variable Greenhouse 1 | Greenhouse 1 Temperature | $Greenhouse1Temperature
[V] Set Temperature Variable Greenhouse 2 | Greenhouse 2 Temp-Humidity | $[NAME]
[V] Set Today's Date | $DateToday
Copy of Weather Getter | $ClockVariable60 | $owWindGust | $owFeelsLike | $[NAME] | $owUVI | $owTemp | $owWindDirection | $owCurrentCondition | $owCurrentHumidity | $owSnowToday | $SummaryToday | $owTimeStampFormatted | $owRainToday | $RainHour
Date Getter | $Month
Flood Lights OFF @ Sunset For Holiday Lights | House Flood Lights
[NAME] | $ClockVariable15 | $PoolControllerStatus | Pushover
Offline Report | Pushover
Rain Hour Converted to Inches | $RainHour | $owRainHourConverted
Rain Today Converted to Inches | $owRainToday | $owRainConverted
[NAME] | [NAME] | 10 Minute Timer
Snow Today Converted to Inches | $owSnowToday | $SnowTodayConverted
Temporary Morning Heat ON 69 | Temp Morning Heat | My ecobee
[NAME] | $HighTempToday | $LowTempToday