Project Management
Discussion List
-
RAG status formula using TODAY and end dateIn Formulas and FunctionsHey smartsheet community, any help fixing this RAG status formula? I am trying to automatically show RYGG balls dependant on the end date and today's date. With the exception of cancelled and complete tasks; any task with the end date TOD…
-
Stacked Bar Chart with PercentagesIn Formulas and FunctionsHi There! I am trying to track and present progress on key milestones made by multiple countries to share with our donor. I want to be able to show the average percentage completed overall for the milestone, but comprised of that show the …
-
Combined Calendar Report - Can I Automate Labels?In Using SmartsheetHello! I am a Project Manager trying to redesign how my company uses Smartsheet internally, and I'm hoping to use Smartsheet to replace several other tools we currently use. My current goal is to create a Dashboard where an individual on …
-
Project Health Formula to Auto Populate a SymbolIn Formulas and FunctionsHi I have a formula that flags the health of each row (task) via a RAG status. Green is healthy, Amber is at risk or in progress and Red is a failure. This is set up to work off the start date and % complete. However, it just isn't right. …Answered - Pending Review 186 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Form selection of dropdown list inserts choice with hyperlinkIn Formulas and FunctionsWe have a project management Smartsheet where we have about 3 different "standard work" choices - these are selections where the requirements are the same each time. This list may grow later. On our request form, I'd like the use…
-
Using a master sheet to change multiple sheetsIn Using SmartsheetCurrently, I have a project template that I use for opening a new location. Our company is typically working on 5 or more location opening projects at a time. When changes need to be made to the basic structure of the project plan (i.e. de…
-
Update Parent Row based on Child statusIn Formulas and FunctionsHi! I want the Parent row to automatically change with the most recent Child Row status. I currently do this manually so I have to update the status in 2 different rows. Right now I have this: =IF(COUNTIFS(CHILDREN(), "Open") &…Answered - Pending Review 413 views 4 comments 0 points Most recent by Kelly Moore Formulas and Functions
-
Send as attachment - PDF + Excel ?In Formulas and FunctionsHi Guys Another day another Smartsheet query - is it possible when sending a report as a scheduled attachment to send both the PDF & the Excel in the same email? Or is there a workaround in order to do so? Thanks! :)
-
End Date is auto-filled, how to stop?In Formulas and FunctionsHi All, I have created a sheet for my team and outside of normal columns, we have an extra "Target End Date" to track if we meet target or not. Please see picture. However, the Actual End Date is auto-filled every time I enter …
