What type of columns can the Formula column not interact with?

The Formula column on Monday.com is designed to perform calculations and return values based on the data in other columns. However, it cannot interact with column summary values, which are aggregations of data from multiple items within that column. This is because the summary values are not individual item data points that the Formula column can reference directly; they represent a whole column’s data rather than the data of specific rows.

On the other hand, the Formula column can interact with other data types such as date columns and text columns, depending on the calculations being performed. For instance, you can create formulas that manipulate date values to calculate differences between dates or derive a textual output based on the content of text columns. Columns containing images are visual elements that are not subjected to numerical calculation, but they do not directly obstruct the workings of a formula since they do not provide data for calculations. Therefore, the distinct nature of summary values stands out as the reason why the Formula column has no interaction with them.