I am aware of the process to click a link on the spreadsheet. However, is there a way where the user of the sheet can directly click on the link?
I am trying to prepare a decision tree where, once a user selects a specific option and clicks it (which is a hyperlink) on the spreadsheet, he/she should be directed to the link.
e.g. What should you do if the product is not procured?
Options available for the users are (check whether the order status is one of the following):
- Waiting for Inventory
- Purchase order is generated
- Product is listed Out of Stock
I have already created links for the 3 options, however I am unable to find a simpler way to directly click on the link.