Forum Discussion

JimG1's avatar
JimG1
Copper Contributor
Sep 06, 2023

Using Excel to Help Users Determine Action

I'd love some advice on how to accomplish the following.

I have an application that I'm training users on how to use it. When it comes to creating new users, my admin users want a simple way to determine what role they should assign to new users.

 

I have created a matrix of available user roles and the permissions each role has in the application. What I'd like to create is a "checkbox" type Excel workbook that allows my admin users to select the permissions they want a new user to have and then have Excel spit out "Hey, based on your selections, you should assign the XXXX role for the new user."

 

How do I accomplish this in Excel?

 

JimG

2 Replies

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    What I'd like to create is a "checkbox" type Excel workbook

    How about online form like MS Form to collect infomation with checkboxes?
    • JimG1's avatar
      JimG1
      Copper Contributor
      You misunderstand my post and my question.

Resources