Hi everyone,

I have a column (Exact Employees) which contains the exact number of employees a company has and a column (Employees) with a Single Select field with brackets like:

1 to 10

11 to 25

etc.

I’d like to have a script that would do something like:

Check “Exact Employees” and if number is between 1 and 10, then select 1 to 10 in “Employees” and so on.

Can someone help me get started?

Thanks