-
Cut and paste rows from Excel without importing an entire sheet
I have created a sheet for registrations and only want to add new registrations from an existing spreadsheet. How do I cut or copy and paste the new rows without importing the entire Excel spreadsheet? I only need to add the new information.
-
Creating multiple row entries from one submitted web form?
Back with (what I believe to be) another obscure question that I don't know how to search for nor find an answer to. I'm attempting to work around the issue of not being able to have more than two dates in a row - we run news stories to multiple audiences so would prefer to have one row for each story, with up to ~10 date…
-
Report Request: Show new discussions added within a time period
I would like to be able to publish any rows that have recieved new comments over the past 7 days along with what those comments are. Is that possible?
-
Improving the context of answers to community questions
Hi all, can I suggest that as there are lots of new users to the community since it was launched only a few months ago, that existing and new members add a little detail about themselves? That extra info should make it easier to see the context in which a question is being framed, so the answer is more appropriate?…
-
Setting up alerts on a Report
We have a report that is populated when a cell is checked off from a tracking list. I would like to send an alert to co-worker when a new row is added to the report.
-
TICKBOXES IN SMARTSHEET
I am trying to record telemarketing results for multiple users, who want a simple sheet to "tick" one of four boxes as to the quality of the call, every time they make one. This needs to be automatically updated, and centralised onto a single sheet, with the ability to breakdown into user and date. Ideally, we dont wish to…
-
Send Update Request - Need more time
Is there a way to give the contact more time to fill out a Send Update Request? The request is timing out before they submit their update.
-
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…
-
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.…
-
Webform copy for someone other than the creator
The help center states "there isn't a way to have the web form confirmation email sent to the sheet owner or collaborators," however,the collaborator would like to an email that looks like the form and not a Notification which looks like the sheet. His reasoning is that he wants to print the webform which is vertical and…
