Project Management
Discussion List
-
Cell Linking - Updating Source SheetIn Formulas and FunctionsNot sure if this has been answered before and if so, apologies, I could not find anything relevant. My team has been trying to link from a 'schedule' sheet out to smaller sheets so that we no longer have to manually update the smaller she…Answered - Pending Review 13 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Control Center optional template issueIn Apps, Integrations, and Add OnsHi All, We are using Control Center for our projects, we use it with 4 different countries and every country has it own set of templates that they can select when creating a project. So in total we have 16 optional templates that are unre…Answered - Pending Review 40 views 3 comments 0 points Most recent by Bobby Jocz Apps, Integrations, and Add Ons
-
How to combine multiple project plans into one, but keep separate editing access?In Using SmartsheetI am running a program that contains 17 different workstreams, and each workstream has a separate PM that is running their own individual plan. We want a view where you can see all of the workstreams together in a 'program' plan. We conso…Answered - Pending Review 12 views 1 comment 0 points Most recent by SoS | Dan Palenchar Using Smartsheet
-
Index Match Across Multiple SheetsIn Formulas and FunctionsHi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX(…
-
Links connecting one sheet to another are not working - how can I resolve this?In Formulas and FunctionsLinks between sheets are not working. I've seen status updates on this from people in the past, but am not sure if this is an ongoing issue or if it has been resolved. If I need to submit a ticket to SmartSheet, please advise or advise how…Answered - Pending Review 13 views 4 comments 0 points Most recent by kdashnaw Formulas and Functions
-
Can you lock comments so that those with certain permissions cannot see them?In Formulas and FunctionsI know you can lock rows and columns, but can you lock certain comments so that those with certain access levels cannot see what is in the comments? For example, we are giving view only access to certain people on a stakeholder list, but…
-
Trying to return a value once, but not when cell value changesIn Formulas and FunctionsSorry I don't really know how to phrase this. Basically in the projects we have, we get a quote from a vendor, and they automatically enter it into our project sheets. Because this can change to a lower price or cancelled altogether we se…
-
Is it possible to reset only a part of the baseline date during the project ?In Using SmartsheetRegarding the start date /end date baseline function, I'm wondering if it is possible to reset the baseline date just for a part of my planning. For example, if I plan my baseline at the start of my project for every task and I activated t…
-
Averaging Health Status for Parent Rows based on Average of Children Rows in RYG.In Formulas and FunctionsHi everyone, I am looking to find the best formula to give me the average health status in RYG for the parent rows (#2). I have tried IF formulas but keep getting parsed errors. Please help. Also looking to get the formula to the sub row (…Answered - Pending Review 47 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions