Hello, I am trying to get a date on the Years of service column. In excel you just minus today's date-start date and it will give you a result with smart sheets I can't figure out how to do it. Can somebody help me?
I know there is a few ways to do that,
There is other date manipulation functions you could use,
Important: I see in your screenshot you are trying the formula in a date column, this formulas will fail on that column because are not dates but numbers.
It looks like your Years of Service column is set to a date type. Try changing it to a text/number type.