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

Nicolas Bobroff
Nicolas Bobroff ✭
edited 12/09/19 in Archived 2015 Posts

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

Tags:
· Share on FacebookShare on Twitter

Comments

  • SoniaR
    SoniaR ✭

    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). 

     

    Thanks,

    Sonia

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories