IF statement changing numeric to text

I'm attempting to convert a numeric field to a text field based on the the content. So far I have the following formula but it's not working. IF( [Time in Role] =< 1 ,"Less than 1 year", [Time in...

formulas

PaulPeterson2
5 months ago
What output are you getting in the field? I do see some issues with the formulam but would like to know what results you are currently seeing. Also, what is the field type for Time in Role?
Initial observation:
Condition 1 should be [Time in Role] < 1 if you are looking for less than a year. currently you will get 1 year and less
The other conditions should follow this format:
[Time in Role] > year and [Time in Role] <= end year
This is untested, but should get you pointed in the right direction

PaulPeterson2

Qrew Trainee

What output are you getting in the field? I do see some issues with the formulam but would like to know what results you are currently seeing. Also, what is the field type for Time in Role?

Initial observation:
Condition 1 should be [Time in Role] < 1 if you are looking for less than a year. currently you will get 1 year and less

The other conditions should follow this format:
[Time in Role] > year and [Time in Role] <= end year

This is untested, but should get you pointed in the right direction

Qrew Member

5 months ago

I'm not getting any output, only syntax error. This helped, thanks!

Forum Discussion

IF statement changing numeric to text