-
% Complete in Project Template seems to be off.
Working in a Smartsheet Project Template. I've put in my % complete info for each WSB row. The Parent % complete is reporting back 21%, while a selection of the rows shows that the average should be 19% Does anyone have a logical explanation for this?
-
Outlook custom emails
Hi, Is there a way for Smartsheet to capture Requests For Information from contractors and suppliers if they have a dedicated email address for a sheet? I'm new to SS so not sure what is out there. I know there is an outlook plug-in to push content to a Sheet but what if a team member just emailed 'abcdefg@smartsheet',…
-
Ever invented or thought about how to use Smartsheet for the holiday season?
Hi, Im curious about what the community has built or dreamt of building for holiday season needs? templates for sending /automating holiday cards? gift list and shopping? menu/party planning? santa list etc? Im interested in ideas to spread some help and joy via smartsheet this pending season.
-
Resource View by Project
Hi I wonder if anyone might be able to shed some light on an issue I'm experiencing. I'm a new Smartsheet user so I could well be doing something wrong or expecting Smartsheet to work in a way that it doesn't. I'll set out the issue below and if anyone can explain what I'm doing wrong, or if there is a different way to do…
-
Calculate new start time for whole schedule
Hi there! As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected. Column 1: Start Time (HH:MM) Column 2: End Time (HH:MM) Column 3: duration in minutes Column 4: new start time (HH:MM) how can I arrange a formula so that once entering a new start time in…
-
COUNTIFS with NOT CONTAINS from a Referenced sheet with two columns selected
Hello! I've searched through a few community posts but cannot seem to find an answer to my formula I'm trying to calculate how many products we have in one column that are not "done" from another column that are both being referenced from the same sheet where: {product} = Product1, Product2 {status} = Done, Ready for…
-
Formula for Health column
I would like the color of the circle in the Health column (formatted from a drop down list of RYGB balls) to change based on the status selected in the previous column containing a drop down list of "Not started", "In Progress", "Behind" and "Completed". Is this possible?
-
Snapshots and Logic Driven Archiving
Hey all! We are just about done and ready to parallel pilot our Request Management through Operationalization to Close solution and was wondering if there's an easy way (or hard way) to do the following: Use Case 1: Right now my teams' weekly status updates (which is a cross-sheet report between Intake and Metadata) keeps…
-
Ignore negative: Calculate time between dates ignore negative numbers
I am running a formula to calculate the days between a start date and today(), if the number is less than 25 then it inserts today's date in a cell. That cell is then used to trigger an email to a user for action. If the start date is in the past the calculated days between is a negative. I want the formula to ignore the…
-
Multiple IF Statements -- Status Updates
Hello, I am trying to put together a sheet that reflects as a holistic "Status Update" depending on whether or not something has been "Approved", is "Pending", or has been "Denied". I attached a photo that shows what I am trying to get my sheet to reflect and what is happening with returned values. Here are the examples of…