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
Can excel sheet be used as a reference in Smartsheet?
I have a State account
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt
