Project Management
Discussion List
-
What licensing is required for collaborators, commenters etc please?In Using SmartsheetHi, I have searched but can't find a definitive answer. If I create a project plan in Smartsheet and want people to comment, update or collaborate in general, which of those need a paid license please? To clarify, in this scenario the cre…
-
Design QuestionIn Using SmartsheetI have taken over management of our sheets for my department and have been trying to redesign them to make them more fluid, functional and all around nicer and implement it at the start of the year. We use Smartsheets for construction proj…
-
Automation - need a required for meeting reminderIn Formulas and FunctionsHi all, I currently have created a form to which PMs submit their project to discuss on a weekly call for authorisation. I want to incorporate a 'Required Members' reminder for the likes of VPs and stakeholders which they then reply to i…
-
What is wrong with my automated colour column formula?In Formulas and FunctionsI am looking to automate the colour “status” for my rows based on the health of the action - a calculation based on the ‘% Complete’ and the ‘Due Date’. The goal is to demonstrate a contextual health status. For example, even if an action …Answered - Pending Review 32 views 12 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
COUNTIFS formula with OR and FIND formulasIn Formulas and FunctionsHello all! I have a trouble with one formula. The idea is, that I need to find an engineer name in AT LEAST (that's why I am using OR) one of the columns. The problem is, that the second range is a contact list so I need to use a FIND form…Answered - Pending Review 12 views 2 comments 0 points Most recent by ViktoriiaKocherha Formulas and Functions
-
Project Management Template- Why headers in row 1?In Using SmartsheetHi all, Smartsheets newbie. I've been playing with the project management templates (they're terrific!) and working on customizing them for our needs. My question is, why are column headers repeated in row 1 of in most (maybe all?) of the …
-
Reference Predecessor Cell / INDIRECT FunctionIn Formulas and FunctionsI'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My …Answered - Pending Review 82 views 8 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Project Sheet -- Dependencies reportIn Using SmartsheetWe have project plans that are 1000+ lines with multiple functions/workstreams involved. There are hundreds of dependencies. Instead of clicking on every task to see what the dependencies are, I would like to have a report or a way which w…
-
What to do when I can't view/see or see the Shared Filter options while other Users can?In Using SmartsheetI can't view/see or see the Shared Filter options that a sheet collaborator with Business account created but other collaborators with Free User account can see and use the Shared Filters. What is causing this? I have a Free User account a…
-
Is it possible to stop a flow pulling in a duplicate line itemIn Using SmartsheetHi all, Hope you are all well! With the help of this community i have created a form that will automatically identify how a line item and how long it is before being cancelled. This form will then send emails to Project Managers once we a…Answered - Pending Review 13 views 2 comments 0 points Most recent by Daniel Gill 97 Using Smartsheet
