Formulas

eganjieganji
edited 12/09/19 in Formulas and Functions
05/30/19 Edited 12/09/19

Hi,

I have a formula that works perfectly in Excel but I can not get it to work in Smartsheets. I am having issues finding corresponding functions in Smartsheets. This is the formula and screenshots show what I am getting from them.

=IF(YEARFRAC(G3,F3)>=9,DATE(YEAR(G3)+10,MONTH(G3),DAY(G3)),DATE(YEAR(F3)+19,MONTH(F3),DAY(F3)))

Any ideas?

Screen Shot 05-30-19 at 02.31 PM.PNG

Screen Shot 05-30-19 at 02.40 PM.PNG

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    Here is a link to the list of available smartsheet functions. YEARFRAC is not on the list. https://help.smartsheet.com/functions

  • As Mike said - there is not an equivalent function in Smartsheet - You could consider this as a workaround:

    =IF(NETDAYS([Date of Birth]@row, [Last Patient Visit Date]3) / 360 > 9, DATE(YEAR([Last Patient Visit Date]@row) + 10, MONTH([Last Patient Visit Date]@row), DAY([Last Patient Visit Date]@row)), DATE(YEAR([Date of Birth]@row) + 19, MONTH([Date of Birth]@row), DAY([Date of Birth]@row)))

    I hope this helps you out?

     

    Sean

    2019-05-31_12-30-47.jpg

  • Hello Sean,

    This formula worked out perfectly. Great job!!! Thank you very much.

Sign In or Register to comment.