-
OPPM_One Page Project Manager
I am new to Smartsheet I am a big fan of communicating task and project status via a single page. Does anyone have experience of using Smartsheet using the OPPM format?
-
Outlook calendar
I'm having trouble adding a calendar from a project that I setup in Smartsheet to Outlook. I followed the instructions in the help center, but every time I try to add the calendar in Outlook, nothing happens - the screen just blinks briefly, but the calendar is not available in my Calendar list on the lefthand panel in…
-
Help with a formula
Hello, This is probably a basic question... I am wondering how to input a formula that would allow me to calculate the value/price of something based on a drop-down selection. For instance, column A would have a drop-down options listing different tree species. For example, Redwood, Elm, and Walnut. Column B would have the…
-
IF Statement and CheckBox
I am trying to get a sum of % completion based on a Checkbox. For example, if someone checks off 3-4 of the boxes, and I know the weighting for each box (as shown in the IF statement, I would like to have a sum at the end as per the screenshot. The problem is, the sum isn't working. Any thoughts...?
-
Project Sheet: Formatting Parent Row based on Children
Does anyone know a way through formula and formatting rules to highlight a parent row cell (finish) if any of its child rows have a blank value in finish? We want to avoid the parent finish date looking deceiving in reports when only some of the children finish dates are known.
-
Report on Previous Entries
Hello! I'm curious what would be the best way to report a cells previous vs current value. For example, last month we had a status set to 15%, and this month it's updated to 20%. I'd like to see the 5% change as a percentage, or even an icon on a sight. Can this be done natively through the changelog, or would I have to…
-
'Conditional'/Multiple Predecessors
Is it possible for start date of a task to be based on dates tied to one of two other tasks? E.g. Task 2 must start not more that 10 days from completion of Task 1. Under normal circumstances, this allows task 2 to start not more than 10 days from start date of task 3. If start date of task 3 must be accelerated, however,…
-
Tracking / Notifications - Replica Sheet for Next Year
I track a lot of items for my company that individuals are responsible for completing. I have notifications set up for each item so those individuals will get email reminders ahead of the due dates. If I want to take 2017's calendar and create a 2018 calendar, how can I keep those notifications. It would take forever to…
-
Project Cashflow
Hi there, I would like to be able to create a month by month cashflow report from a Smartsheet Project (or a number of projects) based on the schedule and Budget Amount entered into each row. ie. Take a standard Project in Smartsheet, which has rows for each task (along with STart and Finish times) and has additional…
-
Outlook Add In not working
I do not recall a Windows update occurring last week, however, this morning when I went to use the Outlook add-in, it is suddenly not working. Non-descriptive message: "Whoops! Our bad, something unexpected happened..." Anyone else running into this all of a sudden, or at some time in the past?