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:
How do I set a date in the future and then count down the remaining days until that date? For example, my future date is 8/17/18 and each day I want it to show how many days are remaining until 8/17/18.
=[Column3]1 - TODAY()
where [Column3]1 holds the future date in question.
Nick
Nick,
Thanks for the information and that did the trick.
Hi All, I feel like I am missing something simple. I am creating a new project via a Portfolio template. They are working great except for the pre-built data integration in the template is not in the new project. Its easy to re-add them but not a good experience for users. Any ideas on what I am forgetting. With the…
Hi all, I'm trying to link Google Calendar events to specific rows in a sheet so that when an event is rescheduled in Google Calendar, the date on the matching Smartsheet row updates automatically. From what I can see, the native integration doesn't cover this. Publishing a sheet to Google Calendar is one way (Smartsheet…
Please help! =COUNTIFS([Points Received]:[Points Received], "Incident", [Employee ID #]:[Employee ID #], $[Employee ID #]@row, Date:Date, <=[Today's Date]5528, Date:Date, >=[Incident 24 Months]5528) + COUNTIFS([Points Received]:[Points Received], "Accident", [Employee ID #]:[Employee ID #], $[Employee ID #]@row, Date:Date,…
