Relation to a math column missing option for "greater than or equal to"

I have two data sheets

  1. Users; every time someone performs an action, it increments across various columns. A column for ‘count’ adds the total across increments.
  2. Songs; contains a template column to form a relation to the count column in Users.

For example.

  • Play a song: column gets a value of 1
  • Create a song: that column gets a value of 1
  • so on and so on
  • The “count” column adds the various previous columns into a current total
    This part works fine.

In the Songs sheet, a template column pulls in the value from the Count column. This part works fine.

I went to build an action that would reference that “rel_” template column and realized there are not options for numbers. Specifically, I’m looking for the “equals,” “greater than or equal to,” and “less than or equal to” options. It only shows me options for text such as “includes.”
This shows you the options currently available.

How do I filter an action based on a template relation column that contains numbers?

Multiply the template column by 1… that will force it back to a number

Jackpot! Thank you.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.