I am using a pre-built template dashboard and am trying to see the data that the chart widget is referencing which is displaying on the dashboard but am unable to determine what data is being used.
If you click on the Edit button in the top left corner of the dashboard, you will be able to edit the widgets.
Hovering over a widget then clicking on the small pencil icon in the top right corner will allow you to edit the widget.
For chart widgets, clicking on the Edit Data button in the Chart & Data section (shown in the screenshot) will bring up a list of all sheets and reports that you have access to for use in a chart widget (this will be on the left of the dialog box that pops up). The sheet or report with the blue checkmark next to it is the one currently being used. GENERALLY speaking, if a sheet or report is already being used, the list of sheets and reports available for use will start with the sheet or report being used somewhere close to the middle of the displayed list as soon as the dialog box opens.
I have two columns expired date and status. When the expired date is in the past, I want the status column to show "expired" How do I set up this automation?
We are a wholesale distributor and are looking for a way we can track multiple (10-20) construction projects in one workspace. In each project, there is project header information that needs to be statused and tracked, and a bill of materials that we need to upload via CSV to the project. This BOM material includes…
I want to do what I think is a simple cross-table join. I have a table with a list of project week start dates (lets assume 40 weeks). I have a separate table with a list of all resources working on the project (lets assume 20 resources) I would like an automated way to create a new master table which has a row for unique…
