Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Excel lookup formula in smartsheet

edited 12/09/19 in Archived 2017 Posts

I have a risk register created in excel that has a tab named "lists".  There are lookup formulas in the risk register that references data in the "lists" tab.  Since smartsheet won't let me make tabs to my Register, how can I make the copied formula work.

Here is an example of the formula:


I have attached .png files of the register, and the lists

Risk Factor.png

Consequence Rating.png

Probability Rating.png



This discussion has been closed.