It's not liking that at all haha invalid expression

That is working a charm! Thank you! How can I stack this up with more conditions? For example now if the Task name contains a 2 I would now like another field to be pulled in? I have copied the expression and added it after separate with a comma how I would anticipate but I am getting an error!Thank...

Hi Manish - that's giving me N/A unfortunately. I have checked that the {name} is pulling from Task and the Custom Field is pulling on Project. 

I am trying to create a calculated field for a series of Tasks. If the Task name Contains the number "1" I need it to display a date from the Project custom form.I was able to return a True/False result using CONTAINS and I have been able to display the date without a condition but when combining th...

Hi Justin - any idea on the calculation for this? 

I have got a calculated field to manipulate a date. The Months and Days that pull are single digit for example May appears as '5' or the first of the month appears as '1'.I would like these single digit dates to appear as two digit so 1st May would appear as 01/05.This is the expression - can it be ...

I am creating an internal reference number using the CONCAT function and the date forms part of this. I need to convert a Custom Date field into an all numerical format of YYYY/MM/DD. If this is possible in a Calculated Field in a Custom Form this would great for any help!

Hi Manish Thanks so much for this! I added the first expression related to BAU and it worked perfectly. I have then added the expression for Existing, separated by a comma but I am getting an error. Should I be separating them a different way? 

I am trying to create a calculated field in an Issue Custom Form to auto-populate a date for users.I am able to code the date using the 'ADDWEEKDAYS()' expression based on a custom date field used earlier in the form but I would like to add a certain complexity based on an another selection made  in...

Hi Madalyn - I think it was to do with the size of the custom fields which I remedied and then the above worked 