Auto Prompt

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!