Camilla has attended:
Project Intro Intermediate course
Creating expressions for non-default columns
How do I create if expressions for non-default colunmns?
RE: Creating expressions for non-default columns
Hi Camilla
Thank you for your question. You can access fields that can be customised by going to Tools > Cusomize > Fields.
By choosing a field type (e.g Text) and selecting one of the available fields (e.g. Text1) you can set a formula that incorporates and If expression. Click on the Formula... button and then click on Function. From the General sub menu choose IIF (this is the equivalent of an IF Function)
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew