-
PLANNED VERSUS ACTUAL PROGRESS
hi, is there a way that i can see the planned versus actual progress of the project ? baseline versus actual? thanks.
-
Past Due Dates
I am having some difficulty in adding a formula so I can track how many days past due a task is. I've searched other disccussions and I have not been succesful. I am using the "Project Sheet" templete and I have it filled out with actual dates and durations and Predecessors. I have set up two Conditional Formating…
-
Sorting/Filtering on the mobile site
Wehn my people use smartsheet on a phone or tablet they are not able to sort or filter a column. Is there something we are doing wrong or is this feature not available on a phone/tablet? If not, any work around ideas?
-
Cell linking - finding the next empty row on another sheet
Hi, Looking for a way to link a cell in each new sheet to the 1st column of the next open row in a summary sheet. I have a template sheet and summary sheet. I would like to create a number of sheets from the template and then display some info from the sheet in one row on the summary sheet. It looks like this is commonly…
-
COUNTIF formula across Multiple Columns
I am trying to count the number of times an individual's name is input across multiple columns. For example, an individual may be an "Account Manager" on one project but a "Project Manager" on another. I want to count the total number of projects this individual is involved with, regardles the role. Below is the formula…
-
"Web Page" Smartsheet Solution
I need to make available, to external companies, files that contain different types of design and manufacturing standards. We currently have an external, legacy website that hosts a smaller set of similar documents. This current system won't be scalable for handling the additional requirements. Is anyone out there using…
-
Subtotal Formula
Hi, I want to take the subtotal of the rows, after applying filter. in excel I was using =subtotal(9, C2:C100), where C2 to C100 are the data field. I tried to apply the same forumula but not working on smartsheet. Is there a way to calculate subtoal of the filtered rows? Please guide.
-
Copy links
I use link between sheets a lot. Sometime I have to link to the same cell a lot of times - but it is not possible to just copy another cell with a link. Could this be a possibility? It would make my work much easier, since it takes time to make the link to another cell in another sheet. Thanks.
-
Linking blank cell
Hi, I am not being able to link a blank cell to another sheet. My goal is to make data of few columns of other two sheets identical to the data of master sheet, where my team will fill the cell with data later [Currently it is blank] OR is there any way that i can link the column itself to another sheet ? Thanks. Deepak.
-
Creating a report, Not able to select column that exsists on sheet.
Hello, I use the same sheet frequently and change the title/calendar to fit the need of the project. I also use the same report, and generally just change the sheet the search is restricted to in order to generate calendars for sub contractors for the specific project. However, I'm having a strange error. I'm trying to…