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  

When I am completing data in a report Custom Field I can use shift and enter to drop a line in the field. This shortcut isn't working for Mac users in my instance - does anyone know how I can do this?

Hi Skye How would this work? Add a Calculated Custom Field to the Report and Group on that? 

I have a Type Ahead Name Field in the system that I am trying to Group by and pull into a Chart Report.When I group by the Name the Chart view shows as No Value with a solid block as if there is no Grouping applied. I can group by the ID but then the ID's show in the Chart view and make the report d...