LinkedIn
Twitter
I have the columns Hours Used and Minutes Consumed on my dataset and they are on Number Type with their own formula for their respective calculations:
The output is correct when they're on my source table (google sheet):
But when they are presented on an xlsx attachment from an automation (for reports), the output for Hours Used and Minutes Consumed turns into like this:
As you can see, they are in another format. I tried to input <<[Hours Used]*1000>> on my xlsx template but there is no effect on the report. I'm asking for help on how to fix this one. I appreciate it.
Solved
1 ACCEPTED SOLUTION
Please try below.
1) Download the template created by the app to your computer. After downlaoding, change the format of columns "Hours Used" and "Minutes consumed" to number format with zero decimal places.
2) Now re-upload this template back to your related automation BOT as teamplate.
The example below shows the report produced after formating the number columns.
The number formats now show as below.
Please try below.
1) Download the template created by the app to your computer. After downlaoding, change the format of columns "Hours Used" and "Minutes consumed" to number format with zero decimal places.
2) Now re-upload this template back to your related automation BOT as teamplate.
The example below shows the report produced after formating the number columns.
The number formats now show as below.
