-
How to create webhook for sheet as third party?
Hi Smartsheet Community, Our startup has fairly simple use case to update our backend systems when a third party Smartsheet document is updated that we have view access to. Based on our research, I understand that as a third party, the only way to receive webhook notification updates is by using a Smartsheet WorkApp which…
-
How to show most frequent status per unique groupings?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Can I update a cell date in one sheet and have another sheet also update to the same date?
Hi, I'm very new to using Smartsheet. We have two different smartsheets with the same project in both. I'd like to update a date in the date column and have it automatically update in the other smartsheet. is there a way to do this? if so, could you please provide a step-by-step for a fellow new user? Cheers, thank you!
-
Alert when tasks are planned to finish after a date in another task (deadline)
Hello all! I am trying to program a sheet to alert users when any finish date in the sheet goes beyond a specific deadline task in the sheet. I foresee it working like: User changes a start date, and several tasks down the dependency waterfall, a finish date gets pushed beyond the deadline task's date, and an error shows…
-
How can I create a 19page Smartsheet form?
I have a 19page form with 38 base questions that to trigger upto 152 additional questions per base question based on No/Yes logic. Smartsheet has a column limit of 200 columns, any ideas on how to string it together so that the survey continuation is triggers.
-
Showing Sheet Summary Data in Another Sheet?
I am building SheetB to compare my budget by categories (data entered manually for now) against my actual expenses (entered in SheetA - totals for each category are part of my Sheet Summary data). Is there a way to reference those Sheet Summary totals in SheetB? Ideally, I will then be able to use SheetB to create charts…
-
Is the Docusign Integration Bidirectional?
Can anyone tell me if the Docusign Integration is Bidrectional or not? Use Case Present users with a Docusign form which ask them to read a waiver and enter three pieces of information: Name Email Event identifier And then sign the form. We want the data from the three fields to populate a Smartsheet grid and then attach…
-
Organizing data in sheets
Hello Smartsheet Community! I am working on a project where I need to schedule staff into various sessions on different dates. I have set up a form and have collected this data. I listed each date as a question so I have 10 form fields with dates as column headers (Thursday, March 2) and staff choose either available or…
-
Formula Help: Count number of time "Yes" occurs in a row?
Hi there! I am trying to write a formula that will count the number of times "Yes" appears across multiple columns in a single row. I am new to SmartSheet and having a hard time writing the formula. Can someone provide some guidance?
-
Publish Report Link as Read Only- HTML
Publish report links with as Read Only-HTML like you are able to publish sheets to have the ability to remove attachments and comments. Hiding Columms still allows users think the links to view that attachments, and incorporating the report into a widget takes too much time