Can you assist me with the formula for the # of years and month?
Hiring Date is Oct 17, 2002 === What is the years and months of Tenure
I'm so sorry! Can't believe I missed that step. This should do it:
Training Delivery Manager / Charter Communications
Assuming you have a [Hiring Date] column you could use a formula like:
This isn't exact as there are not 30 days in every month, but it gives you a close approximation. The formula to get the exact number of months would be slightly more complicated.
Hope this helps!
The result is 22 Years 271Months from your formula.... What I need is... for Oct 17, 2001 ---22 years 3 months Thanks.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hello! I have not written formulas in quite some time, and need some help. I want to check the "Most Recent" box, if it is the most recent submission for that workstream.
Hi Guys, I am looking for the formula to return value for a cell which is in the range. I have one smartsheet like above in the second smartsheet I have cell with date and for example if I have there 08/02/24 I want formula to give back Q3 FY25. Any ideas how can achieve this?
We have a daily task at the beginning of the day in which the first thing to do is to review and track the number of tickets accumulated outside of working hours from our system. The timestamp column comes from the system with the format "datetime", in another separate Smartsheet we are trying to show the date on the top…
©2024. All Rights Reserved Smartsheet Inc.