1 person found this helpful
2 ways of making your prompt yield those values:
a) Put the same formula into the column of the prompt.
b) Create a variable prompt with only these three - named - string options.
thanks got it to work withvariable prompt options
Glad to have been of help. Please close this thread so that other users of the forum know that the thread contains a valid answer to your initial question.