-
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
-
Sharing Templates
Hi, I would like to share multiple templates that I have designed so others can use within my company. Does Smartsheet have the capability to share a blank template?
-
Speed up loading of a Report linked to multiple Sheets
I have a number of Workspaces representing different Projects. I want to be able to Report on specific Sheets within each Workspace. I have several different Reports, each uses data from a different Sheet within the Workspace(s). Whenever a new project (Workspace) is added, I amend the Report data source to include the new…