KrisWalsh✭✭✭✭✭

Comments

  • Andrée is correct. The best way to accomplish this is by using Workspaces. * Have a base Workspace that is your blank template. * When someone wants a copy of it, Right mouse click the Workspace and select 'Save as new'. *see pic* * The default selection maintains the relationship between Sheets, Reports & Dashboards. Good…
  • Hi Jawanza, How about this? If your task is done or not due yet, then Green: IF(OR($[% Complete]2 = 1,$[End Date]2 > TODAY()), "Green", If your task is not done and the due date has past then Red, otherwise Yellow: IF(AND($[% Complete]2 < 1,$[End Date]2 <= TODAY()), "Red", "Yellow")) All together: =IF(OR($[% Complete]2 =…
  • 暂时命名您的复选框列to A, B, C & D. =IF($D1 = 1, "Full", IF($C1 = 1, "Three Quarter", IF($B1 = 1, "Half", IF($A1 = 1, "Quarter", "Empty")))) Once the formula is in place & working, change the column names back to whatever they were before & the formula will update accordingly.
  • Because you said there would be many E-Book projects, here are a few suggestions based on my experience. * One sheet for each project * Each sheet has a Status column for rows in the sheet (Not Started, On Track, Off Track, On Hold, At Risk, Complete) * In addition, each sheet as a Project Status column for the status of…
  • Assuming you want to know how may days until an item is due... Column Name: Days until Due Date | Column Type: Text/Number =[Due Date]1 - TODAY() I would use conditional formatting to change the color to red if it is less than zero and the task is NOT complete. You might want to take a look at Reminders, too. They are very…
  • Hi Yessica! Best Practice: Keep your own version of the Smartsheet Formulas Template and create a "My Favorite Formulas" section. You'll find yourself going back to it over and over again. (1) Formula to automatically populate a due date (2 weeks after start date). =$[Start Date]1 + 14 ? Will land on any day of the week…
  • We use Smartsheet Sync for Google Forms for branching. It works great!
  • Here is our workaround for "Cross-Sheet Unique ID". Hope it helps! We have 6 groups in our PMO. Each project is a sheet. There are currently ~200 active projects (sheets). Each group has an Auto Number column in their Project Plan template with a 3 letter prefix for their group. TAD-00001, EOP-00001, etc. We do not create…
Avatar