I was wondering that.  Let me try that and see. 

Hi, I thought I had this calculated expression written correctly, but everything returns "Other".  Have I missed some syntax somewhere or should I be using a different expression. IFIN({DE:*PRM Project Type}, "Adhoc", "Funded- Signature", "Funded-P&P","Funded-A&E","Conferences/Events/Webinars", "Fun...

Perfect!  That worked.  And thank you for the article!

Hi Alex,Thanks.  It is a project form.  I did try that at first but when it gave the error I thought maybe it needed a command so I added the concat.  The concat does work for the owner id field so I don't think it is that syntax.It is telling me that owner name is not a field in my system but I hav...

Hi,I'm trying to pull the project owner name into a custom field on a form.  Owner name is not an option in the fields, but ownerID is.  I was able to use syntax for the name and it shows it in the calculation result (see image) but gives an error and won't let me save the expression.Any ideas on ho...

Thanks so much.   That works to add the project if project or task but the hour type is showing blank if it is not project time or task time.  Any ideas there? Thank you! Heather