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

MaryKate_1

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.