-
Chart on Sights
Hi, I created a chart on SS labs. I want to display the chart on my project dashboard. How can I do this? Y
-
Extracting a Date from a Text String into a Date Column
I have data sent from my CRM into Smartsheet. The CRM will only export an appointment date and time together as one cell, formatted as: 2/09/2016 8:00:00 AM. I need the date to be in a separate column for filtering and formatting purposes. I've used a MID function to separate the date from the time using this formula:…
-
Sharing filtered information only
I want to use SS to share information with two of my supply chain who are competitors. Therefore I want to filter out the information which applies to each company, and only allow them to see this info. Is there a way to share the sheet with filters applied? or if the sheet is shared will they be able to view the entire…
-
Formula to change date based on adjacent drop down menu
I'm trying to set up a tool inventory, to help keep track of the location of all our big ticket items. I've created a row for each tool. Asides from various descriptive colums, I have one column set as a drop down list (listing the numerous job sites the tool might be pulled to). I also have a Date Pulled column, to show…
-
Meeting agendas
Hi All, I am wondering if some of you have ideas regarding setting up agendas for meetings. We have various sheets for example: Sales, Finance, Tasks, Schedules, etc. I want to design agendas for each weekly meeting. How can I get only specific items pulled through from all the sheets for what is relevant for a certain…
-
Workbook template set for new project
Hi there, My first post to this forum and somewhat new user to Smartsheet. Can anyone advise if below is possible and if yes, how to do this or point me to help on this topic. Thanks a million! *** I want to create a template set for a suite of document that I need to create for every project. What I do today is use an…
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
-
Page Layout with a table and summaries
Smartsheet often shows a nice calculation at the top of a sheet. Say a list of dealers. The first five lines of the sheet have a nice summary box with the number of dealer in each state calculated or soemthing like that. Now the sheet column headers are really matching the data table not the summary table. So name,…
-
How to start building project roll-up with 110 dropdown names to pick also
Where to start, project roll-up, don't want a done of linked cells if can avoid it. Need it simple for user interface. Today using Excel just type it in, pick the color for the cell. The color means something based on a key. There is high-level corrdination of the overall program, then high-level for a project, then…
-
Creating a cell link to a different sheet with different working days
Dear community, I have created a sheet for Data Center migration planning. By definition these activities are planned during normal working days (Mon-Fri) but the migrations happen during weekends, as it requires to stop servers and so that's the lowest impact to services. This sheet has defined all days as working days to…