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.

Use web form to return row or report from another sheet?

Jamison
Jamison ✭✭✭✭✭
edited 12/09/19 inArchived 2015 Posts

I have a sheet with 2500+ rows of data + attachments. I would like to allow a technical group the ability to complete the web form with some criteria and return the rows that have the specific value in it. Ideally this would be a nice report nicluding any attachments.

Can this be done?

The other option is to give access to the large sheet, lock the rows, and have them search. However, I would prefer a more user friendly approach.

Thank you.

Tags:
· Share on Facebook Share on Twitter

Comments

  • Travis
    Travis Employee
    edited 06/08/15

    Hi Jamison, web forms are used to add data to a sheet - not to return rows or a report from sheets. Have you used our reporting tool? Reports allow you to pull in rows (including their attachments) from multiple sheets based on criteria you specific. The users will need to be shared to the sheets the report is pulling from but if you don’t want them to have the ability to make changes, you can share the sheets to them as Viewers and the report as Admins (so they can set the criteria but not make any changes).

    Here is information on creating reports:http://help.smartsheet.com/customer/portal/articles/522214-creating-reports

    · Share on Facebook Share on Twitter
  • Jamison
    Jamison ✭✭✭✭✭

    I am hoping my response bumps this back to the top of the list of discussions.

    I think a report would work really well. What I would need to do, since I do not want every person who would be searching this to have to rerun the report builder for thier unique query, is to have some sort of front end (which is why i mentioned the webform) that would take the search information (product name, part number, division, etc.) and use it to run the report.

    Can that be done? And if not, is it something that could be accomplished with the API?

    · Share on Facebook Share on Twitter
  • Travis
    Travis Employee
    edited 02/17/16

    Apart from reporting, it should be possible to do with the API. There is information on our API on our developers portal://www.santa-greenland.com/developers

    You can email[email protected]if you have any questions about the API.

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

HI @Jbob<\/a> <\/p>

Thanks for the post. I have tried to recreate your example (in a simple way) to see where the issue is.<\/p>

In mine the column called Date and the column called Max per Value are BOTH Date data types.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

I have exposed the formula I have used in the last column to show how the Max per Value is coming through.<\/p>

I know this has simplified your original question, but can you see how the Max(Collect()) statement works here?<\/p>

Does this help at all?<\/p>

So in yours: <\/p>

=MAX(COLLECT({CQ Hours Data Range 6}, {CQ Hours Data Range 2}, Model@row, {CQ Hours Data Range 5}, Batch@row),<\/strong>)<\/p>

Range 6 and the column you have written this formula into must be Date fields and you have an extra comma where you don't need it! Just between the last two )). This comma will cause an error.<\/p>

Kind regards<\/p>

Debbie<\/p>"},{"commentID":386369,"body":"

Hello Debbie,<\/p>

Appreciate your help, that worked perfectly!<\/p>

Thank you!<\/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":107881,"type":"question","name":"Formula to show duration days in Months, Weeks, and Days","excerpt":"I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…","snippet":"I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns…","categoryID":322,"dateInserted":"2023-07-20T19:40:32+00:00","dateUpdated":"2023-07-20T19:41:46+00:00","dateLastComment":"2023-07-21T12:14:38+00:00","insertUserID":139118,"insertUser":{"userID":139118,"name":"Kayla","url":"https:\/\/community.smartsheet.com\/profile\/Kayla","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4jS9-j6AyQ!-s9Rt9CEFHw!9QXda4h64Go","dateLastActive":"2023-07-21T12:44:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":139118,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-21T12:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":35,"score":null,"hot":3379825510,"url":"https:\/\/community.smartsheet.com\/discussion\/107881\/formula-to-show-duration-days-in-months-weeks-and-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107881\/formula-to-show-duration-days-in-months-weeks-and-days","format":"Rich","tagIDs":[219,254,324],"lastPost":{"discussionID":107881,"commentID":386370,"name":"Re: Formula to show duration days in Months, Weeks, and Days","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386370#Comment_386370","dateInserted":"2023-07-21T12:14:38+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-21T12:47:44+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/E719S9G7QZCH\/example.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Example.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-21T00:25:23+00:00","dateAnswered":"2023-07-20T20:20:50+00:00","acceptedAnswers":[{"commentID":386281,"body":"

Try something like this...<\/p>


<\/p>

Months:<\/p>

=INT([Duration Days]@row \/ 30)<\/p>


<\/p>

Weeks:<\/p>

=INT(([Duration Days]@row - (Months@row * 30)) \/ 7)<\/p>


<\/p>

Days:<\/p>

=[Duration Days]@row - ((Weeks@row * 7) + (Months@row * 30))<\/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":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"}]},{"discussionID":107861,"type":"question","name":"Can I trigger an event when selecting a value from a dropdown list?","excerpt":"Dear all, I have a column with a dropdown list. At the beginning of a project, the value for each dropdown\/task is set to \"Not started\". As soon as the vale for the first task changes, I would like to change another field's value ([Start Date]1) to today's date. But only if it didn't contain a value yet, so I can use it to…","snippet":"Dear all, I have a column with a dropdown list. At the beginning of a project, the value for each dropdown\/task is set to \"Not started\". As soon as the vale for the first task…","categoryID":322,"dateInserted":"2023-07-20T15:52:09+00:00","dateUpdated":null,"dateLastComment":"2023-07-21T12:21:11+00:00","insertUserID":161446,"insertUser":{"userID":161446,"name":"MarkFX","url":"https:\/\/community.smartsheet.com\/profile\/MarkFX","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T09:39:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-21T12:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":16,"countViews":44,"score":null,"hot":3379820000,"url":"https:\/\/community.smartsheet.com\/discussion\/107861\/can-i-trigger-an-event-when-selecting-a-value-from-a-dropdown-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107861\/can-i-trigger-an-event-when-selecting-a-value-from-a-dropdown-list","format":"Rich","lastPost":{"discussionID":107861,"commentID":386372,"name":"Re: Can I trigger an event when selecting a value from a dropdown list?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386372#Comment_386372","dateInserted":"2023-07-21T12:21:11+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-21T12:47:44+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-21T09:39:50+00:00","dateAnswered":"2023-07-21T08:29:51+00:00","acceptedAnswers":[{"commentID":386336,"body":"

@MarkFX<\/a> <\/p>

I just replicated your workflow, and it works for me.<\/p>

Can you share some screenshots of the sheet so the columns are visible?<\/strong> (Delete\/replace any confidential\/sensitive information before sharing) That would make it easier to help.<\/p>

Also, do you save after you make the change?<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Using MAX to get latest date by criteria

    Hello, I am trying get the latest date in a list, subject to criteria but MAX COLLECT does not seem to work. What am I doing wrong? I have tried both a text column and a date column. =MAX(COLLECT({CQ Hours Data Range 6}, {CQ Hours Data Range 2}, Model@row, {CQ Hours Data Range 5}, Batch@row),) Appreciate any suggestions!

  • Formula to show duration days in Months, Weeks, and Days

    我有一个维uration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…

  • Can I trigger an event when selecting a value from a dropdown list?

    Dear all, I have a column with a dropdown list. At the beginning of a project, the value for each dropdown/task is set to "Not started". As soon as the vale for the first task changes, I would like to change another field's value ([Start Date]1) to today's date. But only if it didn't contain a value yet, so I can use it to…