I have this form for grading, the values should be decimal from 1.0 up to 7.0
I need a formula to change de value in case one teacher writes 56 so it will become 5.6, so that "if the number is bigger that 10 and less than 70, that value should be divided by 10
I made an action
set the values of some columns in this row
FIRST GRADE = IF(AND([FIRST_GRADE] >= 10 [FIRST_GRADE] <= 70, [FIRST_GRADE] / 10, [FIRST_GRADE])
I set the action on form submission but nothing happends. Any ideas?