I have two columns. Col1 and Col2. Col1 is a multivalue field, with the property set to show multivalues as separate entries, so each line in this view appears to have one value. Col2 is where I need help. I need col2 to show “Manager”, “Author” or “Reader” based on the field that the name in column 1 was pulled from. The challenge is since the VALUE from column 1 is not really a single value of a field, I can’t get a handle on it. (I could if I was using lotus script with view navigator and etc) but since this is a column formula I’m stuck. Please help thanks!!!
Subject: Column Formula
If I understand this correctly:
col1 = multiValueFieldName
col2 = display “Manager,” “Author,” or “Reader” based on value in multiValueFieldName
Have you tried to set the “Programmatic Use” (the beanie tab on Column Properties Box) name value for col1 to something like “this_column” and in col2 use the formula:
@If(this_column = “(some value)”;
"Manager";
this_column = "(another value)";
"Author";
"Reader"
)
I think this may help you or at least get you off an running…
HTH
Subject: RE: Column Formula
AH yes I think that will work, thank you!