Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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).
Thanks,
Sonia
