Expand my Community achievements bar.

SOLVED

How to write formula in the field in Custom Form

Avatar

Level 2

Hello:) 

In the Custom Form I have Multi-select dropdown field 'Risks / Issues', then the next field is Single Line text 'Comments' 

How to write formula that if you select in the 'Risks / Issues' 'no risks/ issues' then in the 'Comments' field will appear n/a text. Otherwise leave empty. 

 

I tried this one in the Comments field: 

IF({DE:Risks / Issues}="n/a", "n/a", "")
but doesn't work 
 
Can someone please help 
 
Thanks, 
Mariola
1 Accepted Solution

Avatar

Correct answer by
Level 4

Hi Mariola,

 

Since "Comments" is a text field, the calculation will not work for that. You can try the following:

View solution in original post

1 Reply

Avatar

Correct answer by
Level 4

Hi Mariola,

 

Since "Comments" is a text field, the calculation will not work for that. You can try the following: