-
Attachment line numbers
When I send attachments from a sheet that has many attachments it is sometimes hard to find which line that particular item came from, which would be very helpful. Is it possible to add the source line number in the automated email? And if the item is attached at the sheet level just have it say that? I'm sure I'm missing…
-
Send copy of Web Form Request to Multiple People
It there a way that when a user completes filling out a web form that when they "check" off Send me a copy of my responses....that they can put multiple email address's in the field? example: jane.doe@test.com; stan.form@test.com
-
Formula for Parent, Child, and Non-parent/child rows
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent rows and non-parent/non-child rows to copy the same-row Project ID and child rows to copy the parent Rep_Project_ID number.…
-
Report that features tomorrow as due date
Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that. And using "is in the…
-
Data Entry With a Filter
OK - I have a sheet that tracks our invoices by VENDOR. We have several vendors in alphabetical order as the "parent" rows and underneath each vendor are their respective invoices (children). The sheet is long so I create a filter to pull up a specific vendor. In the first blank row under that vendor I type in the…
-
Sharing a Folder
good Morning i have a workspace with 3 differen Folders. Is it possible to share each folder with differen people instead of settin all sharers at sheet level? Regards
-
Time with fractional seconds
Good morning, I am using Smartsheet to track swim time which has a format of minutes:seconds:fractionalseconds (i.e. 5:00.50). I would like to see if anyone has a solution for a couple of issues I am seeing: 1. I would like to use the MIN function to look across multiple cells (swim meets) and pull the minimum for the…
-
Checkbox question
Is there a way to have a checkbox automatically checked if other columns with checkboxes get checked? I have 4 columns with checkboxes and instead of doing value columns for each one I would like to do a summary checkbox and just value one column. If that's not possible, can you set values for more than one column?
-
Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
-
Feature Request: Barcodes & QR codes read/generate/print
Barcodes and QR codes are very useful for invenory management, and simply avoiding mistakes when entering data. They are also a great way to share things quickly (ala WeChat users) I think it would be great if we could add this into SS. 1. Ability to scan/accept Barcodes/QR codes - usually the easy part. 2. Ability to…
