ContributionsMost RecentMost LikesSolutionsSalesforce fields not importing correctly when SF object using lookup command from other SF objectI have a client that uses Salesforce and I'm attempting to setup a table that is linked to an internal Salesforce object. I've set the table up with no issue, selected fields, etc and it all works with the exception of certain fields. Any field within the SF object that is pulling data from another SF object (lookup field) is not transmitted as text, but as an internal SF code of sorts. For example the SF object has a field called "accounts" that lists their customers account name. This is pulling the name from another SF object via lookup where the account name resides. If I look at the object in SF, I see the name, however when I pull the data from this object into QB, I get a series of alphanumeric characters that are essentially gibberish to me. Is there any way to correct this, or will QB only import basic text data from SF? ------------------------------ Jeffrey Jones ------------------------------ Re: Need to setup checkbox formula based on hours:minutesThanks again. Yes I did see that syntax error, stating it wouldn't work due to the value being a duration, but I couldn't figure out how to get around it. I found the Hours formula you listed, but wasn't using it correctly along with the If function. The sad part is I'm far from a new user of QB, as I've been using it close to ten years actually, but have only started getting into the coding portion of it the last couple years. But lesson learned and I'll stop spending hours running in circles and ask experts like yourself when I'm stumped going forward.Re: Need to setup checkbox formula based on hours:minutesThank you! This worked perfectly. I was close, but have a lot to learn about coding.Need to setup checkbox formula based on hours:minutesI have a formula field that returns the hours:minutes of a technician onsite. I want to use this field to create a checkbox formula that returns TRUE if the hours run over 4 hours and FALSE if it runs under 4 hours. I keep getting errors regarding using the if function with a duration and I'm not sure how to get around this if at all possible. Currently trying the syntax below but is not working. Any help is appreciated. If([day 1 time on site]>4,"TRUE","FALSE")