Formulas

eganji

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?

Mike Wilday

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

sean59916

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

eganji

Hello Sean,

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