Sign in to join the conversation:
I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option?
Hi Anna,
From what i know you will have to do the calculations somewhere in the sheen and then pull it to the chart.
See example of the calculations below.
It means you will need to have a small table, one value for each status and calculate count-if based on the status and then add the widget with this data
We need to share a couple of sheets to unlicensed colleagues for viewing and minor editing. Can you advise what’s the best way to handle this? Should we: Ask them to create their own free accounts - what is the downside of this? Is there an “expiration” on their account and will they no longer be able to view/edit sheets…
I am attempting to use a timeline from a portfolio report on my dashboard but after setting it up I keep receiving an error - Columns used to configure this widget have been deleted or changed. I have took all filters and grouping off of my report and it still showing this error. I don't know how I can get around this…
Hello, I have a general question. looking to move a SHEET from one workspace to another. That sheet has a FORM and Workflow Alerts set up. Will that disrupt my workflow and inactivate the form link? Just want to confirm what I need to do to ensure the SHEET and workflow alerts don't break. User is the same. Second question…
