-
Automatically adding info
I am trying to automate a monthly report that shows what staff member received work apparel. When someone received work apparel, they have to pay taxes on it. So I created a form for staff to fill out when they received the apparel. It has the Date Dispensed, Name, Description of the apparel and how many they took. With…
-
Pulling data from one sheet to another
I am currently in the process of creating a dashboard. I was originally planning to use cellular formulas to pull this data. The original formula I was using is: =COUNTIFS({JBO Type}, "Overhead", {Date}, IFERROR(MONTH(@cell), "") = 11) However, this formula is returning an improper total, it reads "24" when it should be…
-
Copying Attachments Between Sheets
Is there any way to copy attachments between sheets automatically without copying a row? I have a master intake sheet where each row is a different project and attachments can be added. I would like those same attachments to be available in the metadata sheet of the individual project. Basically, the project metadata sheet…
-
Dashboard Chart Widget Axis changes with each refresh
The axis label on the dashboard chart widgets consistently changes with each refresh and will not maintain the order that it is in on the Report. This is pulling from a summary report. Occurring on a monthly report widget and quarterly. I have a Support ticket in, but no good response. This is happening on multiple…
-
How do I pull data using Reports API from 10000ft into Power BI
Hi, I am trying to import data from the 10000ft reports using the following API link, but I get the message 'Not Found'. https://api.10000ft.com/api/v1/reports/rows?view=time_fees_hours&time_frame=this_week&auth=<URL-ENCODED-TOKEN> Can anybody help? Thanks
-
How can I share a report to an user without sharing him paper, source of report?
I would share some data in a report with an user but I do not want share with him the paper, source of report. The aim is to use report as a tool able to visualize data for all users and to track and modify data on a paper used only by our project managers. Thank's you
-
Search on Dashboard
Any suggestions on the following without using Dynamic View: Dashboard has a report Search Box where a user enters data that return the list from the report directly into the Dashboard thoughts?
-
Report - Filter on current user does not work
Hi, I created a report to filter on current user. It works with myself, but not for another team mate. She sees data assigned to me vs herself. Any idea how to troubleshoot / fix? Report as I see it (my team mate should see her name, but she sees mine) Filter on current users
-
Sales pipeline with sort (need child/parent row stays together)
I have a sheet that has child/parent rows and which I can sort by dropdown list order (see below pics) So here are my questions: 1.) how can I have a report where it only shows the current user AND that the child/parent row are together when sorted in the report 2.) I want the sort to be "sort by dropdown list", is that…
-
Export or Print Multiple Reports Through Action Drop Down
Anyone know of a way to batch export or print reports? Planning on running upwards of 50 reports and I want to be able to print through the actions drop down to capture all of them at once rather than opening individually and clicking print one by one.
