Best answer

ClickUp - QBO returns actual formula instead of value

Forum|Forum|3 years ago
August 3, 2022
4 replies
64 views

paches86
Beginner

I’m trying to push the Time Estimate value from ClickUp as a Time Entry on Quickbooks online.

Zapier retrieves it in miliseconds so i customized a formula that returns the valie in the HH:MM format QB requieres. However, Zapier retrieves the formula, not the value.

Any idea how I can capture that value?

Best answer by paches86

Ok so I figure this out. At least to achieve what I needed which is to bring a HH:MM value format to QBO.

I just used zapper formatting and utilities to split the hours and the minutes and formatting.

Division to get Time estimate in milliseconds to hours (decimal) (divide the value by 3,600,000)
FLOOR to get the hours integer separated.
Result of #1 minus #2 to get decimals (minutes)
Multiply #3 x 60 to get actual minutes.
Round to 0 decimals # 4
Format #5 to get the MM format. If < 10 then “0”&”result of #5), of not #5
Then in the Create time entry step I just added #2:#6 and it works beautifully

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+6

Jillian
Zapier Staff
Forum|Forum|3 years ago
August 4, 2022

Hey @paches86! I’m wondering if there’s an issue in how you’ve formatted your formula and the editor thinks you’ve inserted text. Mind posting up a screenshot for us to take a look at? Please be sure to not include any personal information like addresses, e-mails, or phone numbers in the screenshot.

Thanks!

Like

P

paches86
Author
Beginner
Answer
Forum|Forum|3 years ago
August 14, 2022

Ok so I figure this out. At least to achieve what I needed which is to bring a HH:MM value format to QBO.

I just used zapper formatting and utilities to split the hours and the minutes and formatting.

Division to get Time estimate in milliseconds to hours (decimal) (divide the value by 3,600,000)
FLOOR to get the hours integer separated.
Result of #1 minus #2 to get decimals (minutes)
Multiply #3 x 60 to get actual minutes.
Round to 0 decimals # 4
Format #5 to get the MM format. If < 10 then “0”&”result of #5), of not #5
Then in the Create time entry step I just added #2:#6 and it works beautifully

Like

+6

Jillian
Zapier Staff
Forum|Forum|3 years ago
August 15, 2022

Hey @paches86! Thanks so much for swinging back in and letting us know what you figured out. Sounds like this one was not apparent or obvious in the least, so I hope this helps another QBO user in the future.