-
Editable Report with Shared Sheet that's Hidden/Locked
Is there a way to make the report editable by the user with a sheet that is shared to them as "Editor - cannot share", but making it to where they can't alter the actual properties of the sheet itself? Thanks in advance!
-
Resizing Sight To Eliminate Blank Space
Hello, I'm having an issue with a sight where there is blank space at the bottom of the sight which will not go away. This looks ok when using the sight in smartsheet, but when it's embedded in another application using an iframe, it leaves some space. That means the height of the frame has to be large enough to span the…
-
Work Insights - column not available to select
I have a column in a sheet that uses a formula (If this field is not blank then status is "Complete"). However, on Work Insights, this column is not available to select. Why?
-
Publishing vs. Sharing Forms -> Reports -> Dashboards
Hi! I have a sheet the collects information through a form. So, a user submits a request through the form, it gets recorded in the sheet. One sheet holds all user requests. I have a report created that filters the rows based on the current user (and the email in the original form). This report is then displayed in a…
-
Dynamic Drop Down lists from another column either within the sheet or from another sheet
I've searched, but everyone seems to say that this is not an option at the moment, are there any work arounds? I want to create a page where someone can create a product id number based on several factors, i.e. category, model number, color, country, end customer I'f like osmeone to be able to select the category (call it…
-
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