-
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…
-
Dropdown list - Update from the dev team ?
Hi everyone, TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used... I'm using Smartsheet more and more to provide simple solutions to my clients regarding their work (finance, managing team, project...). I…
-
Move Rows to Another Sheet...that contain formulas
Hello! Has anybody had experience trying to automatically move a row containing formulas to a new sheet? I am trying to pre-populate cells with formulas that would apply on a different sheet so that they will be ready to go once moved over during a workflow.
-
Would Report have the ability to filter columns as per new features announced in ENGAGE 2020?
Hi All, I created a report using report builder that consolidates data from different project plans at the lower level with a set criteria. I am trying to see if there is a way to filter KPI within the report. As I am aware that Smartsheet will be rolling new features in the report announced in ENGAGE 2020, I wanted to…
-
COUNTIFS PARENT cross reference
In my summary sheet, I need to cross reference the PARENT rows in my data sheet (status) to count the number of open non-conformities (with less than 100% complete). Basically, the counting in summary sheet needs to take into consideration two conditions in the status sheet: Be a PARENT row, and % complete <1 I have tried…
-
Actual % Complete vs. On Schedule % Complete
Hope everyone is doing well? I'm looking for a formula or suggestions to accomplish the following: IF “On schedule % Complete is > Actual % Complete then the task is “Late”, “Red Ball”. IF “On schedule % Complete is < Actual % Complete then the task is “On track”, “Green Ball”. IF “On schedule % Complete is = 0% (Actual %…
