Formulas
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?
Comments
-
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
-
Hello Sean,
This formula worked out perfectly. Great job!!! Thank you very much.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!