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

Find more posts tagged with

Formulas

Conditional Formatting

Comments

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