-
Project Metadata Sheet no updating
Hello I've completed the project intake form which has populated the Project Intake Sheet in the PMO Template set. I've then followed the instructions and copied the Project ID into the Project ID column in the Project Metadata sheet. When I do this, the rest of the data, e.g. Project Name, Project Manager etc is just…
-
Calculate planned % complete
Hello, I could not find this anywhere so hoping someone can help. I need to calculate the planned % complete based on the total duration of my project and elasped days. I want to exclude weekends and CDN and USA holidays. We do not track buydget so I am trying to get around calculating using the real earned value formulas.…
-
How do I change a date format in a formula to long date format?
Hello! I am setting up a meeting agenda in WorkApps and have a date column that displays the date in a long date format to avoid confusion between regions: Sep 28, 2020. I would like this date format to show in a formula. The pre-set formula is simply =[Next meeting]@row + " Meeting Agenda", so that looks like this:…
-
Data Mesh
Hello, I'm using data mesh to bring information from other sheet(projects in this case) I have them linked with a column named "helper" I noticed that new data is not being added, however existing information is updated once a change is made in the source sheet. if I select copy and add data it adds duplicates at the end…
-
Outlook Integration - Attachment Handling Improvement
When I attach emails to different fields in my Smartsheet, I need to uncheck all the attachments that the system includes (i.e. all the graphics in an email signature that show up as individual attachments. Can you look into adding a "Select All" checkbox that will allow all attachments to be unchecked at once and only…
-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
-
Workflow Automation Issue
Hello, Workflow automation pushed all projects not just those that were marked complete to completion sheet. Our entire schedule moved over. Why would this happen when the condition requires it to be marked Complete under the status column first?
-
SUMIFS Formula
Hello, i'm trying to SUMIFS our total resources assigned by month and by two specific Occasions "Project Support" and "Commission". It comes out to Incorrect Argument Set confusing me where the formula maybe incorrect. Hoping to get another set of eyes on it.
-
Workflow Administration in Control Center Global Updates
I would love to see the ability to create, update, and administer workflows in Control Center provisioned projects. A few use cases: We recently completed our implementation of Control Center and migrated our live projects into the new framework. Some of the blueprint templates have alerts configured and it would have been…
-
Set Workflow to a specific cell/row not the column
Hi! I'm trying to set up an automatic workflow that will trigger an email alert to a person when a particular cell has been populated but can only seem to be able to do it for a column and not a specific row. Example is: Person A is assigned a client. When Person A completes Task 1, Person B is to Peer Review that…