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
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?