-
I just Cant Seem to figure this one out help please.
Ok In the picture Below Cell ?:? is going to be a drop Down List pulled from a drop down list on a web site. Action wanted : * After I figure out how to link the Drop Down List in F20. * I would like to create a new Row above row 26 and Insert the Drop Down List Slection into B25 instead of in F20. * * Cells…
-
Linking sheets using filters
HI, Newbie here, so forgive my mistakes. I have 2 teams with their own smartsheets in their own workspaces. We are trying to cross link the data. 1 team has its data in the format of each specific product has its own sheet and part of that sheet is a reference to which partners are involved with that product. The partner…
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
Automatic Column Updates?
Hi I am trying to create a formula that is set for the whole column in the sheet. What I want to happen is whenever the Status of the Harvey Ball is full, the "Done" column well create a check mark in the cell. Is this possible? If so, how? Thanks.
-
Master Task List By Resource
We have multiple projects ongoing simultaneously. In each project tasks are assigned to various team members by the managing partner. Is there a way to have a task automatically roll into a master task list for the manager by resource (sort of a pivot table) or a consolidated task list for each resource team member to…
-
No API access to Gantt Fields?
I see in the API documentation that the programatic access of row data in columns of type Predecessor, Duration, etc. is not supported. I'm doing what I've seen many others on this forum try to do; I'm merging several interdependent sheets into one "master" sheet. It need only be a snapshot of the others and needn't…
-
Update Webform URL's included in Folder when Save As New used
We are currently running multiple Projects and have setup a Master Folder with our Process Task lists in using Card View. Within Card View we have links to some Webforms used to capture Data for certain key tasks. The Webform sheets are located in the same folder. When we do Save As New using the Master Folder to Create a…
-
Resource Mgt
Im new to this. If we have one resource alloocated over several sheets and in one sheet/project the resource is required for an extra day, How do we link so that all associated sheets dates are updated? thanks
-
Percent Complete by Cell Color
Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed. Help, please!
-
Does anyone know what NaN% means?
Hi all, I'm getting NaN% appear on my sheets where that cell is linked to another sheet. The source cell appears OK, and I've tried remaking the link, but no affect. Is this the 2000 links I'm running up against? There are a lot on my sheet.... Regards - Roland
