Status Report

Vesta
Vesta ✭✭
edited 12/09/19 in Formulas and Functions

Hi everyone!  I have a grid that contains a form for a status report, that needs to be filled out twice a month-the exact dates will vary each month.  What I am trying to do is twofold; first, create something that will allow me to see who has/hasn't filled out the status report for that period, and secondly, if possible, display that on a dashboard.  It could also contain something that shows, for each status report period, if they have completed their report.  I've been thinking about how to do this for a few days now, with no luck.  I would love something that looks like the attached, but the example is still just a grid and doesn't get me on the dashboard... any help would be appreciated!

 

example.PNG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!