-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Curriculum Project Management
Hello, I recently became a curriculum manager and want to utilize Smartsheet to oversee the annual curriculum, the coordinators, and take on a project management role. Has anyone used smartsheet in a similar way and if so, do you have an example of what you're using? Do you have any tips for me as I get started? I…
-
dealing with distant dates
Hi everyone, I really need help here. My project is of the long sort (several years). I seem to have a problem with far away dates: smartsheet won't 'take' a date in 2018 (I type it or select it in the calender and the box goes blank). My other question is: how do I hides dates (I don't need the next few months on the…
-
Send Update Requests based on a Contact column
Is there a way to send an Update Request based on a Contact List column? I have a large group of people and I need them to update their personal contact information. Rather than filling it out new every year, I would like them to receive it in a format where they can simply hit submit if none of the information has…
-
creating formula to add many non-adjacent cells
I need to sum/add many (~120) non adjacent cells. They are all in a single column. When I create a formula and start clicking in the cells to include, I keep being returned to the bottom of the sheet where the formula is calculated. Then I have to scroll back up to the top of the sheet to access the next cell I want to…
-
How can I get Calendar view info to wrap so it can display more than 20 characters?
I want to be able to show more than the 20-25 characters limited in the display of a calendar entry. e.g., I need to be able to show an "Issue No. (10 characters) + an Impact" which can be a list of multiple things. I would not mind if it wraps around into a second row as long as it displays all the information needed by…
-
Feature Requests: Viewable attachments
I was exploring Airtable.com, and they have a feature I would love to see in Smartsheet. You can view attachments without having to download them. I would like to be able to associate a small graphic with each line of a sheet without users having to download each one separately. I have a spreadsheet of test data that I…
-
Using SUMIF when column is not blank
Hello, I am trying to sum only the values of the children in one column for which the corresponding cell from another column is not blank. I tried this formula: =SUMIFS(CHILDREN(Amount25)), (CHILDREN([Date Paid]25), NOT BLANK), but it did not work. Is it even possible? Thanks!
-
Looking for similar to collaborate
Short version. 2 years sales manager. 1.5 smartsheet. Company sizee start 500k annually today 3 million. Smartsheet is our only platform. Phoenix. Haven't found anyone that will take me seriously local on smartsheet, have used freelance again lack familiarity. Tried support no follow up back. We have local guy trying to…
