Changes

Jump to: navigation, search

Calculated Field

316 bytes added, 22:05, 20 January 2011
no edit summary
* if(''conditional statement'',''value if true'',''value if false'')
'''ExampleExamples'''* If the field value is '''Pending Approval''' display the word ''Submitted''', otherwise display the field value: if([this]='Pending Approval','Submitted',[this]) * If the field value (statusid in this example) is one of 6 different statusids, display the word ''Submitted''', otherwise display the field value:
if([11] in (9681,10134,10028,9685,9683,9901),'Submitted',[this])
0
edits

Navigation menu