Conditional Rollup within Glide data editor

In your log sheet create an if then column and fill it with true if the log has a meter reading greater than zero. Then create a template that joins the machine ID and the if then value. In your machine sheet, create a template of machine ID and the word ‘true’. Now change your relation to use those templates to link machine to log. Your rollup should then show the max date of a log that has a meter reading.

3 Likes