The IF-Column is on the left side of your Streamsheet next to column A and offers one individual IF-Cell per row.
IF-Cells are a different version of the IF() function, but instead of influencing only one cell they influence all cells in their row. When the given condition is met, the IF-Cell states “TRUE” (green background), if not it states “FALSE” (red background), either" turning on" or “off” the affiliated row.
In this scenario the IF-Cell is checking if the “Interesting Data” from the Inbox is over a value of 200 (see edit row). As long as this condition is not met, the whole row is not calculated. If at some point the value exceeds the set condition, the row would be set active again and the MQTT.PUBLISH() function in B14 would send a message.
This is just one of many example cases the IF-Cell could be used. What is your favorite use cases?