Utilizing IF to open different sheet upon condition

BillDav ✭✭
edited 12/09/19 in Formulas and Functions

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)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!