Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
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: