Utilizing IF to open different sheet upon condition

BillDav

Hello everyone,

I have been googling this for a while, and decided it would just be easier to sign up for the forums and post my question.

What I am trying to do should be a simple IF function statement whereas if a dropdown list entry is hit in a cell, then the user is pointed to another sheet.

e.g. Dropdown box 1 on Sheet 1 has several entries to include 'not started,' 'in progress,' and 'completed.'  Whenever a cell is populated with the dropdown selection of 'complete' I want another sheet to pop up.  The purpose behind this is to have the user fill out information in Sheet 2 after completing work in Sheet 1

I have tried several renditions of the below but am missing something, likely simple.

=IF([DropdownList1] = "completed", https://app.smartsheet.com/b/home?lx=YJb034R8j7yEQbTdTGc_Xw)

 

BillDav

I thought I had it by referencing the other sheet, but I am still showing #unparseable in the formula cell:

=if(DropdownList = 'completed',{High Severity Survey Range 1})