Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Calculating Years Of Service

Hi Everyone,


I currently am importing a sheet to manage in SmartSheets and one of my cell formulas is not functioning. Can someone please let me know if there is a work around to this. Currently in excel I have it as a =datedif formula. Smart Sheet currently shows the following error in the sheet #unparseable.


Thank You


  • Hi Nicolas - 


    Smartsheet doesn't have a datedif formula, but you can subtract one date from another and it will give you the difference in days. An example formula is:


    =[End Date]1 - [Start Date]1


    Be sure to adjust this formula to match your column titles (the words between the brackets [ ] are the column titles). 




This discussion has been closed.