how many ongoing and done to show using a pie chart? please suggest ideas. I appreciate any help. Have a nice day
Step 1: So you will make a metric within the Sheet Summary function on the sheet A3 Database. One metric will be a COUNTIF referencing the the ONGOING steps and one will be a COUNTIFS referening the DONE Steps
Step 2: Then you create a Sheet Summary Report based on the A3 Database, pull in both of those metrics you created.
Step 3: Create a dashboard, select Pie Chart and have the data be the Sheet Summary Row Report Referenced in Step 2
Would it be beneficial to include an option that enables a forms user to complete a form and then initiate a new submission for the same form. Currently, users can navigate back using the browser's back button, but they are required to overwrite all the previous answers, which can be cumbersome.
I have data in Excel that I need to import on a weekly basis into Smartsheet (lets say columns A-F) I would like to have columns (lets say G-H) with formulas. How do I import data each week replacing the previous week's data (only columns A-F) without overwriting the formulas? Is it possible to do this via Datashuttle or…
We had a Latest Comment column but the Column Type wasn't accurate. Showing as a Text / Number type. I tried to resolve this and I get the error "There is already a Latest Comment column in the sheet". To try to resolve, I created another column and deleted the original. However this still hasn't fixed the issue. There are…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.