-
Automating RYG balls based on Due date and completion status
Im having an issues creating this formula and was hoping someone could help improve on my formula. Im trying to create a HEALTH flag marked "Green" if the task is not due today, "Yellow" if the task is due today, and "Red" if the task is past due. However, the HEALTH flag should stay blank if: 1) the STATUS…
-
VLOOKUP Calculation Lag
Hi, I am having problem with a VLOOKUP process. Our current process flow is as follows Import data into a "DataDump" sheet through API, at this point each row of data is assigned a number, matching that of the row number (we do this so we can use an index match formula to pull data through to the secondary sheet we call…
-
Magazine Project Sheet?
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
-
Free Cost Benefit Analysis Templates
There is a link to new templates: https://www.smartsheet.com/free-cost-benefit-analysis-templates I can't find these templates Smartsheet, is anyone able to find or access inside of smartsheets?
-
Decision matrix template?
Hi all, I am new to smartsheet, and have created a decision matrix style spreadsheet to compare special schools for my son, giving ratings according to different criteria. I want to then be able to work out. Instead of stumbling along to work it out, I assume someone will have something suitable? If not sure what I am…
-
Clock Hour Progress Management
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…
-
Cell Linking Blank Templates
I'm looking to create a "Packet" of 3 sheets that cell link together to be used for multiple projects. Is it possible to create 2-3 Blank Templates set up to cell link with one another, without it getting altered when the blank template is used again for a different project? Hopefully this explaination makes sense. Thanks…
-
SharePoint Deployment Plan Template
Does anyone have a Template plan to build and deploy Sharepoint?
-
Budget vs actual calculation
Hello, I was wondering why the formatting of this document is auto-crossing out the actual calculation? Is it suppose to be doing this? Is there a way to make it not do this?
-
Revision Control - Best Practice
With an AS9100 Audit coming up for us, many have asked if our Smartsheet templates need to be revision controlled. Does anyone have any insight on this they could share?