Custom Formula Field always giving an error

Custom Formula Field always giving an error

I am trying to make a formula field that gives me a formula based on the words in another field.  

If(Startswith(${Job Openings.Financial Quater 1},'F'),${Job Openings.Salary Position 1}*${Job Openings.Salary Percent},0)

No matter what return type I choose I get the error below.  I need it to search for a boolean, but return a string.  So what is the answer

Make sure you choose a Formula Return Type that matches the type of data your formula produces. (e.g. If your formula returns a string, then you should choose a Formula Return Type. string)



      • Sticky Posts

      • Ask the experts - A live Q & A discussion on Zoho Recruit

        We are delighted to come back with another edition of 'Ask the Experts' community series. This edition, we'll be focussing on everything about Zoho Recruit. The topics will focus on the features that are used/asked by the majority of users and also based

      • Zoho Recruit User Group Meet-up — India 2024

        Hello Zoho Recruit users from India, We’re pleased and excited to announce our 2024 edition of Zoho user group meet-up in India in five cities! In this meet-up, our team of experts will help you understand the intricate nuances to use Zoho Recruit better,