-
Formula to pair staff based on criteria
Hello Smartsheet community, An idea came up recently about pairing staff up who work in different divisions for a random coffee chat to increase staff engagement. We could use Smartsheet to create a form to gather info on staff who are interested in participating and what division they belong in but is there a formula I…
-
Importing Dates
I am importing a manufacturer's shipping report into Smartsheet with Data Shuttle. If the product has not shipped, the manufacture has a date of 00/00/0000. When I import the data, I want the date to be blank, if the date equals 00/00/0000. How can I make the cell blank if it the date imported is 00/00/0000 ??
-
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…
