years column convert to months

Hi everyone
I need your help, I have a Year column with data like 1 year 2 years 3 years etc.....In the training list table when I enter the data I would like you to enter the data in months for example 5 years (60 months)
I hope I explained myself, thanks2.png3.png4.png

Solved Solved
0 2 73
1 ACCEPTED SOLUTION

You have Years as a Number column, so why don't you just multiply it by 12? Wouldn't that give you the desired result?

View solution in original post

2 REPLIES 2

You have Years as a Number column, so why don't you just multiply it by 12? Wouldn't that give you the desired result?

Thanks, I solved it by putting the * sign in the formula field of the application as tw suggested
A thousand thanks
Top Labels in this Space