Has anyone used Smartsheet to build a term tracking sheet and dashboard for boards of directors?


I'm interested in using Smartsheet to build a dashboard and spreadsheet to track term limits for our board of directors. If anyone has done this before and they are willing to share an example, that would be very helpful. Thank you in advance!


  • EHarshbarger

    Hello, a simple way is build a sheet with start date and another column with years of service. You can then build a report to be displayed on your dashboard. Here is a formula you can use for years of service from the start date : =NETDAYS([Hire Date]@row, TODAY(1)) / 365

    You can also use sheet summary and a metric widget, either one will work.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!