Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, WorkApps, or Resource Management. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Popular Tags

@Tony Fronza<\/a> <\/p>

Hey Tony. The % calculation is driven based on what numbers are shown in the half pie chart.<\/p>

So it's taking 1st meeting Completes + SME Follow Ups + Proposals Issued to give you a total. It then divides that total by each of those individually to give you the %.<\/p>

What is the correct info you're looking for it to display? And how is that data\/counts represented in your sheets?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-03 01:11:49","updateUser":{"userID":146191,"name":"Tony Fronza","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Fronza","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xG908UE9JXI!c4C1Jy0cw2Q!tPis-mqrwhr","dateLastActive":"2023-02-03T01:20:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":100606,"type":"question","name":"Form submissions","excerpt":"Is there any way to track forms that have been started, but not submitted?","categoryID":321,"dateInserted":"2023-02-02T20:12:10+00:00","dateUpdated":null,"dateLastComment":"2023-02-02T22:07:05+00:00","insertUserID":157758,"insertUser":{"userID":157758,"name":"Ash Wereley","url":"https:\/\/community.smartsheet.com\/profile\/Ash%20Wereley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A9DE3-86hWU!AeHFAFsmDn8!94lQh_eE8Oo","dateLastActive":"2023-02-02T22:05:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157758,"lastUser":{"userID":157758,"name":"Ash Wereley","url":"https:\/\/community.smartsheet.com\/profile\/Ash%20Wereley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A9DE3-86hWU!AeHFAFsmDn8!94lQh_eE8Oo","dateLastActive":"2023-02-02T22:05:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":20,"score":null,"hot":3350746755,"url":"https:\/\/community.smartsheet.com\/discussion\/100606\/form-submissions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100606\/form-submissions","format":"Rich","tagIDs":[204,219],"lastPost":{"discussionID":100606,"commentID":360298,"name":"Re: Form submissions","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/360298#Comment_360298","dateInserted":"2023-02-02T22:07:05+00:00","insertUserID":157758,"insertUser":{"userID":157758,"name":"Ash Wereley","url":"https:\/\/community.smartsheet.com\/profile\/Ash%20Wereley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A9DE3-86hWU!AeHFAFsmDn8!94lQh_eE8Oo","dateLastActive":"2023-02-02T22:05:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-02T22:07:13+00:00","dateAnswered":"2023-02-02T21:55:56+00:00","acceptedAnswers":[{"commentID":360295,"body":"

Ah ok. <\/p>

You could embed the form on a webpage then track that page's number of hits with Google Analytics (or similar). This will not tell you how many people started the form then abandoned it though. Just how many people hit the page.<\/p>

There are also some plugins<\/a> that track how far down the page was scrolled.<\/p>

@Jodi C<\/a> <\/p>

Try sorting them Descending and add a period to the front of the 3 Month name. See if the period makes the 3 month appear first. If not a period, try another innocent character that doesn't make it look too bad.<\/p>

I know why it's doing that. Its because SmartSheet is only looking at the first letter (or number in this case) and sorting it by that instead of realizing it's a number and seeing if another digit is following it. This is a situation of DumbSheets that needs an Enhancement Request to make it act properly.<\/p>"},{"commentID":360125,"body":"

Hi @Jodi C<\/a> <\/p>

I hope you're well and safe!<\/p>

To add to Mike's excellent advice\/answer.<\/p>

Another option would be to structure it like 01, 02, 03...<\/p>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>