-
Reference two columns to populate a third
Hi, I'm fairly new to Smartsheet and am stuck trying to figure out a formula. I have three columns; 'Due Date', 'Complete' and 'Status'. Due is a XX/XX/XX format, Complete is a drop down with 'Yes or 'No' and Status is blank. Here's what I need: If 'Due Date' is past the current date (today) and Complete = No, then Status…
-
Formula to Activate the Empty, Quarter, Half, Three Quarter, & Full harvey balls in a STATUS column
This discussion was created from comments split from: Formula to Change Harvey Ball Color Based off of a Word. I'm struggling with this formula. I have a drop-down column called STAGE, where there are 17 stages listed. I'd like these options to activate the Empty, Quarter, Half, Three Quarter, and Full harvey balls in a…
-
Report Based on Multi Select Dropdown Column
I have a master schedule that includes a multi select dropdown column for disciplines associated with each individual project. I need to create a report that shows all projects with multiple disciples selected. It needs to allow any combination of disciplines as long as there is more than one selected. Unless I'm missing…
-
Summing a column
Hi, I would like to count all the rows in a column where the value matches a specific cell. I can get this to work using countif however I can't get it to work when the column is variable. For example Cell A1 = "Yellow", Cell D1 is the sum of all [A1 value] yellows in the column where the first row =30, cell E1 is the sum…
-
using a pull down option from a different sheet
I am looking to use one sheet (risks and issues) which I have created to track my small project risks and issues. I want all of them to be in one sheet as the projects are small and do not require a full risk and issue log on their own. I have another sheet with all of the projects listed in them, i would like to reference…
-
Adding to a Complex Formula
Good morning All: I am trying to add RYG to my Formula. Here are my conditions: If 15+ Days Behind Schedule = Red If Between 5-15 Days Behind Schedule = Yellow If 0 or Ahead of Schedule = Green Current Formula without RYG: =IF(ISBLANK([Actual Date]@row), "", IF(AND(ISBLANK([Planned Date]@row), ISDATE([Actual Date]@row)),…
-
concatenation Symbol
hi, is that could to concatenation symbol to to precent cell ? for example 20% with "down" symbol in one cell this picture is in two cells, i want to view in dashboard the precent and the symbol in one cell...
-
Nested IF's Question
@Shannon Heizenrader I am creating a post for you so that your question and whatever solution is found is public. That way anyone having a similar issue can find help and other people are also able to weigh in on a solution that may be a better fit. YOUR QUESTION: Hi, Paul,I am new to the community and using formulas. I…
-
Linked cells not showing in dashboard report
I have a dashboard that surfaces a report in which the duration value cells is blank. The report source data is in a row report. The duration value is visible in the row report. The source the duration value is a sheet in which it is also visible. I have refreshed the report but as the duration is automatic I cant do much…
-
SUMIF Halp!
So I have this issue I would love to solve. I have a Contract Database (Sheet #1) that holds a current contract value for that contract number (216116). My issue is pulling the child row value (Total Contract Value) to another sheet (Sheet #2) using the Job No as criteria. So i'm not sure if SUMIF or SUMIFS will do it…
