-
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…
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Calendar integration for Outlook (2010 et al.)
Hi, We use Smartsheet as an events listing and it would be useful to have integration to Outlook through a calendar. At the moment it displays rows as an all day event it would be beneficial for it to use the time fields we input so that it gives us a true indication of the event timeframe.
