I am trying to create a smartsheet for Attendance for my office. I want to give the option in the smartsheet where my Supervisor can select the nature of offence - it gives them the recommendation of what is the action needs to be taken rather going to the procedures to read everything and find out. Is it possible to create something like that
For eg: It's the 2nd offence, when the supervisor selects 2nd offence - the next cell when should be Recommended Action - for eg "written warning"
Can anyone give me an idea
Help Article Resources
Check out the Formula Handbook template!