Formulas

eganji
eganji ✭✭✭
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!