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)
