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…
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 pro…
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 …
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…
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 tas…
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'…
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 certa…
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 update…
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…
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…