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, please
Visit the Current Forums.
Discussion List
Formula on data from web form
I'm using a web form for a costume contest to be able to have people sign up. Due to the rules, they must be at least 18 years old to compete. I have a formula to display the person's age based off of the current date, but I want this to auto-populate when they submit from the form. Is there a way to do this?
Alerts / Notifications not being received
Can someone help me?
Deleting rows via Smartsheet API 2.0
I get the following error whenever I try to delete a set of rows: com.fasterxml.jackson.core.JsonParseException: Unexpected character ('<' (code 60)): expected a valid value (number, String, array, object, 'true', 'false' or 'null') I am passing the sheet Id, a HashSet of the specified row Ids, and "true" to the deleteRows…
Date Formulas Calculating Back From Deadline with Gantt Functionality
Hello Team Spreadsheet, Ultimately we'd like our company to enter a date that they would like to have their marketing materials and have smartsheet automatically calculate key dates prior to this date including the initial submission date which should be around 5 weeks prior to the end date. Here is our marketing team's…
Web Form Linked to Multiple Smartsheets
Hello, I was wondering if it is possible to create a web form that is linked to multiple smartsheets. I am working on a project for a friend. He is doing some research, and wants to know what things people have tried out and have ratings for these (multiple items on the one form with ratings for each, under each item). To…
Formula to count check boxes in row one of column
I have a questionnaire with multiple columns. Responses are either check boxes or comments. I want to summarise the total check boxes in each column. I can add a column and write a formula to total the checkboxes, but the error message "#1 or 0 expected" appears when the formula is in the same column as the check boxes.…
can i customize a web form link?
i would like to customize a web form link to populate the web form? Is that possible?
Notifications set AFTER sheet already created
We have created a new hire checklist template with a start date cell that drives "due dates" in the sheet. We also created a notification to trigger emails when either "Done" or Due Date" changes are made. Unfortunately, because the notification does not move forward with any new sheets created from the template, we have…
Can web forms update multiple sheets?
I'm wondering if there is a way to create one form that could update fields on more than 1 sheet.
signatures
Hi How can i obtain sign off signatures from staff working remotely onto documents that i have attached onto Smartsheet. They do have access to Smartsheet on their tablets but it would help greatly if they were able to sign Docs i.e Toolbox talks, Training docs etc. many thanks Joe
