I have been tasked with creating a summary of the awards that faculty, staff, and APPs can be nominated for each year. I have broken the awards down by Award Season (Winter, spring, fall, summer), Award Month (January-December), I have listed all the awards out as well. I also have outlined eligible nominees for each award. I will be creating a nomination form that individuals can submit their nominations on. I have a few questions though.
- Can I set up a SmartSheets form that based on the award season that a nominator selects, only applicable awards within that season populate? Also, can I create a form that if the nominator selects they will be nomination a faculty or APP that only applicable awards for those nominee types show up?
- I have all the faculty, APPs, and staff on separate sheets, is there a way to make the sheet that the nomination dumps into flag if someone is nominated for an award that they are not eligible for? For example, a Professor gets nominated for an award that is only for an assistant or associate professor?
- Is there a quick easy way to create a reminder notice 3-months in advance for each award ? So if the award nomination is due in January, nominations need to be made 3- month prior to ensure all applicable application materials are completed in time
- my current column titles include: Award Season, Award Month, Award, Eligible Nominees
Any tips/tricks/suggestions are welcomed/greatly appreciated.
