Project Management
Discussion List
- I have the following formula shown below that changes the Status symbol (Gray/Green/Yellow/Red) based on the Phase/Risk/Change Implementation Date. I tried to update it for a new Phase "Canceled" but …
- I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has…
- Is it possible to do the following: Sheet (A) - A checkbox is checked in Row 4 Sheet (B) - Automatically pulls in a text-field that is in Row 4 If so, how? The purpose is to roll all "At Risk" Descrip…
- I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any differ…
- Have others been experiencing any unusual activity in the past few days? I have been having a number of issues that appear to be related to permissions and reports e.g. A report we use daily suddenly …
- Hi there, I'm trying to create a formula to count when 2 different types of activity in a column ("Key Initiative" and "Initiative" have the value "Complete". I've been trying different ways to organi…
- Hi All, In our PMO function we are looking to create project status reports in Smartsheet that would be a 1 page for a PM to update RAG, finance outlook, comments etc. We would have 1 sheet per projec…
- Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If…
- I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possib…
- I was wondering if I could have a sheet be located in multiple workspaces simultaneously. For example If I wanted to have individual workspaces for each project I am working on, but also have separate…