Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Looking for some suggestions or Ideas
We have been using Smartsheet for a few months now and want to enhance what we do.
We run our customer projects on Smartsheet (all working fine).
We would like to create a Change Control Web Form, however we want to pick up the Customer Name from one place, the project from another and the CCF details would be manually entered into the web form.
* Does anyone know of plugin functionality that we could use?
* If not are there any examples of anything simlar being done elsewhere that we could look at.
* Once the CCF form is completed we want to convert the document ot .PDF and then pass it to docusign for signature capture.
* Once the signature is complete we will want to attach the document it to an element of an existing project.
Any one have any ideas or suggestions?
Simon
Comments
-
SoniaR ✭
Hi Simon -
Since other users in the Community haven't yet responded and since the process seems a bit indepth, I reached out to your Customer Success Associate, Ben. He'll reach out shortly to schedule a phone call to go over your process.
Thanks,
Sonia
-
SoniaR ✭
For others who are interested in this question - two possible solutions are using Zapier or Azuqua (third party applications that make connections between products). The links to both are below:
Zapier:https://zapier.com/
Azuqua:https://www.azuqua.com/
Categories
I think this should work:<\/p>
=IF(COUNTIF(Referencia:Referencia, Referencia@row) > 1, 1)<\/p>
Have a great day.<\/p>
Matt<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[]},{"discussionID":107937,"type":"question","name":"True\/False formula?","excerpt":"I'm trying to figure out a formula to note a \"1\" in the cell if the information in the cell next to it is a certain value, any other value needs to show a \"0\". Is this a \"true\/false\" formula? I figured this out: =IF([Question 1]@row = \"2. I should avoid using the electronic device during the initial connection; however,…","snippet":"I'm trying to figure out a formula to note a \"1\" in the cell if the information in the cell next to it is a certain value, any other value needs to show a \"0\". Is this a…","categoryID":321,"dateInserted":"2023-07-21T20:52:02+00:00","dateUpdated":"2023-07-21T20:53:35+00:00","dateLastComment":"2023-07-21T21:06:17+00:00","insertUserID":159988,"insertUser":{"userID":159988,"name":"Jillian M","url":"https:\/\/community.smartsheet.com\/profile\/Jillian%20M","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bR_Ym_nhTvw!oRnZKN3xkb4!GGy8kNscpSH","dateLastActive":"2023-07-21T21:16:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":159988,"lastUserID":159988,"lastUser":{"userID":159988,"name":"Jillian M","url":"https:\/\/community.smartsheet.com\/profile\/Jillian%20M","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bR_Ym_nhTvw!oRnZKN3xkb4!GGy8kNscpSH","dateLastActive":"2023-07-21T21:16:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3379948099,"url":"https:\/\/community.smartsheet.com\/discussion\/107937\/true-false-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107937\/true-false-formula","format":"Rich","lastPost":{"discussionID":107937,"commentID":386520,"name":"Re: True\/False formula?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386520#Comment_386520","dateInserted":"2023-07-21T21:06:17+00:00","insertUserID":159988,"insertUser":{"userID":159988,"name":"Jillian M","url":"https:\/\/community.smartsheet.com\/profile\/Jillian%20M","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bR_Ym_nhTvw!oRnZKN3xkb4!GGy8kNscpSH","dateLastActive":"2023-07-21T21:16:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-21T20:55:47+00:00","dateAnswered":"2023-07-21T20:53:49+00:00","acceptedAnswers":[{"commentID":386517,"body":"
