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.
Test if cell contains value from list
I have a task list that includes tasks by customer name. Due dates are formula-controlled by an offset from an entry date. Certain customers of ours receive "red carpet" treatment, which requires me to recalculate the due date manually. I would like to try the following automated solution:
Maintain a separate sheet with a list of our Red Carpet customers.
On task sheet, use formula to determine whether the customer for a task matches any of the names from the Red Carpet list.
Is anybody doing something like this? Is it even possible with the client list in a separate sheet?
Thanks for the help!