-
Override formulas and hard code cell values once a row has been locked.
I'd love to have a condition where cells or columns are hardcoded or locked once critiera is met. Currently the lock feature does not override any formulas, so values can change within a locked row should a formula trigger a change. This defeats the purpose of a locked row in my opinion. Since we have many helper columns…
-
Lookup Value and Count based on the input criteria
Hello Team, I am trying to bring a formula to look up a value and bring the corresponding counts. The input sheet will look for the "Date of" column and dynamically generate the Yesterday or Today value based on the formual i have written for "Yesterday/Today" column. There is a person going to enter #New Hires, #Leavers,…
-
How are you scaling a PMO in Smartsheet across multiple departments/workspaces?
Hello everyone! We have a great structure within our own department and looking to expand across our firm. I am looking for insights on how you manage cross‑department projects when each department has its own workspace? Interested in workspace structure and reporting best practices. I appreciate the help.
-
Merged: Workback Schedule
This discussion has been merged.
-
Project Plan Backward Scheduling / Planning
Implementing backward scheduling in Smartsheet would significantly enhance its utility for project managers who work with fixed deadlines and need to calculate start dates based on a target completion date. Backward scheduling allows users to plan by defining end goals and identifying the necessary steps and timelines to…
-
Os meus editores não conseguem editar
Possuo o plano executivo e, até pouco tempo atrás, meus editores conseguiam realizar edições normalmente, sem a necessidade de vínculo como membros pagos.No entanto, nas últimas semanas, eles não têm mais conseguido editar, o que tem impactado negativamente nossas entregas e gerado baixa eficiência nas demandas. Você…
-
Can I create dashboards across workspaces
Am I able to create a dashboard, aggregating projects across multiple workspaces? My team is currently building a dashboard, but our projects aren't on the same workspaces, and don't have the same user permissions for all.
-
Merged: SHARE A FOLDER WITHIN A WORKSPACE
This discussion has been merged.
-
Healthcare Governance Templates
I'm currently working on updating our PPM tool to Smartsheet and I'm looking for templates to utilize that implement a governance process to move projects through the different phases? Does anyone have anything that they could share?
-
Counting number of items from a specific month with multiple criteria
I'm trying to count the number of items that were published for each LOB in our operation during each month. I've tried a dozen different formulas, but I can't seem to get any to work. I currently have a sheet summary with the following: =COUNTIFS([Received Month]:[Received Month], IFERROR(MONTH(@cell ), 0) = 1, (LOB,…