-
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…
-
cell linking and formulas
I am currently working on a Dashboard sheet.. that i would like to count the number of each status within the first sheet. For Example Sheet 1 - contains 150 rows of data with different stages of Status Sheet 2 - Would like to create a formual that would go back to Sheet 1 and count a specific status and advise the count.…
-
NOTIFICATIONS - THANK YOU, THANK YOU!!!
I am beyond thankful for the major improvements to the Notifications area in Smartsheet. I love every aspect, and our team is very pleased. Can't wait for the reminders improvements - that will be an even bigger benefit for us!!! Blessings, Loann
-
Calculate % Comp but retain dependencies
Hello. This seems simple, but it's stumping me. I have a project Gantt chart, and some of the child tasks are simple numerical completions of tasks. In other words, if I have 300 of a certain thing that need to be done, and if I have a user input that he or she has completed 100 of these, I can calculate a completion…
-
Share a Smartsheet folder to auto update added sheets/reports on Sights
Hi, Is there a way that I can share a folder with my team? I want to add the folder on Sights so that when new sheets or reports get added in that folder that it is already accessible in that sights folder without me have to go and add it manually everytime? Or any other suggestions on how new sheets/reports can be…
-
Formula help!!
Please view the screenshot I have provided below. I am attempting to create a formula here that takes the whole assigned to row and the end date row. I want it to show the number of times it shows a certain name, in this case Dean, and if that task is one week past the current date. I would also like two weeks and three…
-
Past Due Reports
GOAL - Tasks Past Due Report for Multi Sheets I have several sheets with the columns set up as seen below: (Type 1) Rows have Tasks with a Contact under Assigned to, "Required" column has a symbol and % Complete is not required so it's left Blank. (Type 2) Rows have Tasks with a Contact Under Assigned to, "Required" column…