-
URL-Query on Dashboards
It would be extremely useful if there was a way to update a form by referencing it in the URL of the dashboard. For instance, referencing the form ID in the dashboard URL, and then referencing the columns in the form as done normally with URL-Query We have redundant tasks which have several columns in the form that need to…
-
How to get automatically an average data based on date rage on a daily basis
We are using form to create performane data per robot per run ( input can be few times a day) I need to start measuring daily avereage for their performance seperately (1 called North 1 called South) but can't figure out formula for it and then I'm assuming creating a chart would be straightforward? but not done it before…
-
Charting Text Dropdown List
Hello, I want to visualize the 4 options in a chart showing the percentage of each one. Also, I would like to show the same percentage for the 4 options within the sheet. I would like to know if one formula is an option or if I must create a column per option. Thanks in advance.
-
Show Percentage from Sheet as Pie Chart in Dashboard
Hi- I have a user on my team who is looking to show progress made against major tasks in his sheet as individual pie charts on a dashboard. For example, if "Milestone 1" is 50% complete, he'd like a pie chart on the dashboard that's just half filled in. Some of these tasks will just have an estimated percentage filled in,…
-
Is it possible to URL-Query an embedded form?
I am wondering if it is possible to prefill an embedded form on a dashboard by referencing the form in the dashboard URL?
-
Can I add an email hyperlink on a dashboard in a rich text widget?
Hello, I can't seem to figure out if I can add an email address that will link the user directly to email (outlook) to send an email. If I highlight the email address in the rich text widget and select the link icon, the link doesn't work. I'm just trying to save time so the user doesn't have to copy the email address and…
-
Dashboard - Embedding links to email addresses
I've seen some past posts on this topic but have not gotten the workaround to work and was hoping that there may be progress on a solution. At the 2020 Engage event, I saw a beautiful dashboard that had images and email links under a title: contacts. I'm trying to create the same on my dashboard. Any help or update? This…
-
Reporting on top parent rows only, not all rows with children
Hi all, I have my projects set up as workstreams rather than phases, with a helper column for phases. I want to add a dashboard widget that lists out each workstream and its % done . In my hunt through the questions I found that I can add a helper column to indicate if a task has children like this: =IF(COUNT(CHILDREN()) >…
-
Change default time frame in published calendar view of report in Dashboard
I have a dashboard that integrates a calendar view of a report. It always opens to a time window of one month, but I'd like to make this default to two weeks. Can this be done? Thanks.
-
Create a dynamic unique count metric sheet for a leaderboard
Hi All, I'm looking for a way to create a leaderboard from a sheet that tracks incoming submissions. We want to track the unique visitors and how many submissions each has created over a period of time, and I'm having zero luck. Any help would be appreciated!