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. Archived 2017 Posts
Archives for June 2017
Discussion List
Emailing reports, except for when blank
I have a report pulling data from several sheets inside my workspace. Essentially it emails the report as an attachment every morning at 9am to my team and lists out open project needs. The question is there are some days when the report is blank (ie. no open project needs). Is it possible to: * not send an email if report…
Count Number of Children Cells that are not blank.
I'm having difficulty with this one. I have a parent row of "Rental Lead" I would like to count the number of child cells in column "Training Course" under the parent "Rental Lead"
speed of sheet
I solved it never mind. Thanks if anyone was looking at this. I have a sheet that is moving very slowly, in fact the entire page doesn't seem to work when I have the sheet open. It is less than 30 columns and 100 rows, however it has many lookups and column references due to the nature of what I am trying to do. below is a…
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
Release Notes Link hard to find
Shaine, I was able to preview the formula Help and Activity Log prior to the release. Really liking the Activity Log for a sheet we recently rolled out that has over 500 users updating it. I'll have to spend more time on the formulas to give feedback. I did notice that the Release…
Cell linking
How do you get the comments to link as well?
Web Form
Can I modify by drag and drop my form to change the layouts instead of just vertically? E.g. "Salutation" "First Name" "Last name" So it will be appear across the page in the form.
Column Properties
How can I set up a column to capture data such as a phone number with xxx (xxx) xxxx xxxx format for Country Code, Area Code and phone number. With dafualt County Code of where there data is coming from or with a default value that can be over-wrtitten by submitter
Attachments need to be attached to an email not linked
We would like to be able to send an email encompassing a couple of rows with attachments (Invoices). The recipient of the email needs to be able to access the invoices as attachments as a computer reads them to populate their accounting program. The computer is unable to read the invoices if they appear as links to…
Help with Column Edit Permissions
Hi All, When I share a sheet with my associate (or visa versa), the person who did not create the sheet is not able to edit the column properties. They are 'grayed' out. I checked and it looks like we both have the same permissions, so Im not sure why that happens. Any advice would be appreciated! Thanks, Robyn