-
Sharing Externally using Control Center
I'm new to using control center and I have an internal team that wants to use it to create client specific reports and dashboards in addition to our internal information. The problem is there is certain information on the sheets that I don't want the external client to have access to, so I can't share a report with them. I…
-
Automated Update Request - some fields editable, others not
Hello, I am trying to set up an automated Update Request for % Complete updates on a project plan. When I test the automation sending it to myself, the system seems to be randomly selecting what item can be updated. For instance, sometimes it is only the task name, others the task name and percentage complete. As I need it…
-
Anyone know how to fix this error in Control Center?
Hi, I keep receiving this error when trying to save one of my blueprints in Control Center, the link to the Work App also crashes when I try to open it saying an associated Work App can't be found. When looking at the Portfolio level Work App, I can't see this blueprint linked on there either. The settings for this…
-
Enhance Smartsheet with 'Current User' Filter Option in Row Report Summary
I would like to suggest an enhancement for Smartsheet that involves refining the Current User filter. It would be beneficial if the filter could include Admins or Owners from viewing the task list if they haven't been assigned any tasks. This feature would enable Admins or Sheet Owners to view tasks even if they haven't…
-
Master Out of Office Calendar Sync with Individual Project Gantts?
Hi! I manage several different projects with separate gantt charts, all with different project teams, and I struggle with cross-checking everyone's ooo schedules when I'm updating timelines. I would ultimately like to find a way to have a Master OOO Calendar that be pulled into the gantt charts based on the people assigned…
-
Formula Help
I have this formula: =IF(CONTAINS("Resource", [Component Type]@row), LOWER(Curriculum@row + IF([Grade/Level]@row <> "", ".g" + [Grade/Level]@row) + IF(Module@row <> "", ".m" + Module@row) + IF([Concept/Topic/Arc]@row <> "", "." + [Concept/Topic/Arc]@row) + IF(Lesson@row <> "", ".l" + Lesson@row) + "." +…
-
How do I share a folder which is located under the Sheets folder?
Although other people are able to see and access the folder, "DigitEYES", located under the Sheets folder. I am unable to give access to it to a new user. I can't find a share function anywhere.
-
List of Same Project name with unique date.
I have four column as show in table below columns. I have one text/number column two date and one duration. "I have nearly 500 projects in my database. Some of these projects share similar names, and among them, certain projects have distinct submission dates despite having the same name. I need to compile a list of…
-
what is the best way to combine contacts from children rows into parent row?
In a contacts column, I would like to combine email addresses that are in 2 children rows into their parent row. I have a helper column that checks a box of the children rows using the formula: =IF(COUNT(ANCESTORS([Protocol ID]@row)) > 0, 1)
-
Index collect from
I have 2 sheets I am working on with; Sheet #1 (POD Archive) - this is where the entries are logged. A single entry could have multiple PO's in column "PO Number". PO numbers were separated by space. Sheet #2 (POV) - contains data imported from an external application using Excel - it contains one PO number per record…