Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

After If-Statement is fulfilled , a string and the fieldvalue as outcome

Hello,

how to add a string to your corresponding fieldvalue.

Example:

=if([DeliveryDate]>0, 'Delivered at [DeliveryDate'], 'Not yet delivered')

Seemingly the single quotes cannot recognized the Fieldname here. I tried with Chr() function, might used it wrong. 

Hope someone can provide the answer.

Best. 

1 Solution

Accepted Solutions
QFabian
Specialist III
Specialist III

Hi, are you doing this in script or expression?

moving one of the sinlge quotes, like this :

=if([DeliveryDate]>0, 'Delivered at ' & [DeliveryDate], 'Not yet delivered')

QFabian

View solution in original post

2 Replies
QFabian
Specialist III
Specialist III

Hi, are you doing this in script or expression?

moving one of the sinlge quotes, like this :

=if([DeliveryDate]>0, 'Delivered at ' & [DeliveryDate], 'Not yet delivered')

QFabian
Applicable88
Creator III
Creator III
Author

Thanks @QFabian ,

it works and it was for a expression in a table.

Best.