Hello, I am considering requiring interviewees perform a skill test in Smartsheet as part of the recruitment process. Has another done this? If so, do you mind sharing what you have? Thank you.
How would you want to use it? What kind of questions and answers would you want to use? (Text, Yes/No or alternatives)
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
I hope that helps!
Have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I was wondering if there was ever a solution for this? I was hoping to have something similar for our recruitment process.
Some basics right off the bat that an experienced Smartsheet system admin should know:
1) Set up an INDEX/MATCH and make it a column formula.
2) Describe the differences between similar commonly used functions, such as CONTAINS and HAS, and what reference they might direct an aspiring power user to get help with formulas and functions.
3) Set up a form with conditional logic and field validation.
4) Create a workflow automation and describe the differences between triggers.
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
In addition to what Jeff Reisman lists (all good suggestions), you should include something around the primary key and/or column properties because that's a basic that, if you get it wrong, it's pretty critical.
I would add to these great ideas, something around problem solving (error messages, unexpected results) and also how they would go about doing something they’ve not done before (where do they start, what is their thought process, where do they go for help, etc). Being able to get started and knowing where to look to fill knowledge gaps can be as, if not more, valuable than knowing the thing. Knowing how to fix something shows they understand what they are doing.
You could also pick a couple of questions from this community and ask them to solve them. That could also be a good exercise in understanding incomplete instructions.
©2024. All Rights Reserved Smartsheet Inc.