Using Switch function in a formula against a multi-entry text fiel

C

Chris_J_S

We have a text field that is populated by our users via table lookup. The
user selects a site code number that is applied against the given task. I
should mention that a given task can be set against multiple sites. We would
like to map the site codes against the definition of the site codes. My
initial reaction is to the mapping in another text field using the Switch
function. The problem though is the fact that there may be multiple answers
in the site field. Is there a way to do something like "contains" like you
would do in EXCEL, instead of "=" when setting up the formula?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...b036-cc3c46298ab6&dg=microsoft.public.project
 
A

Andrew Lavinsky

You mean like the INSTR function that looks in the string to identify text?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a wrap text and an auto complete features? 3
Use TODAY() function as the criteria in a SUMIF formula 1
Adding a voice recording function into MS Project? 3
Adding an auto date function in the task Notes? 0
'Collapse All' button 3
Text field placement in relation to task bar 1
multi WBS plans 6
A new software idea/ invention for MS office 1

Top