-
Does task info about being on critical path exist?
I would like to use something like =IS-ON-CRITICAL-PATH in a formula for the health indicator of a task. Does that function exist? I know Smartsheet can show the CP, but can a task identify itself for being on the CP or not?
-
Formula Question
Hi, I’d like to know if it’s possible to add information from one cell to another using a formula, meaning, I have Column A, and Column B, I’d like that when I enter 1234 in Column A Cell 1, it should also Display 1234 in Column B Cell 1. But without entering any formula in Column B. Is that possible? This way, I can have…
-
COUNTIF formula for a date range
Hi, I am brand new to SmartSheets and trying to pull some high level metrics from a sheet into the Summary section. I have never used complex formulas before in Excel or SmartSheets and am trying to find the most basic answer around how to build a COUNTIF formula to show how monthly numbers for my team. My sheet has 3…
-
Survey Score Formulas
Hi! We are launching a customer satisfaction survey this week. When completed, they will want a dashboard showing results. We have 5 departments with 2 questions each. The scoring is shown in screenshot below. I need to create a formula that will tally results and also give average score. My problem is that it's not just…
-
I need to set a count.
This count needs to count data in the last 7 days and only count data once and not count duplicate data. my goal is to get a count of the names of the people that have completed the form this week at least once, but do not want a total count of all the forms this week. this way i can say that 30/42 people filled out forms…
-
Countifs #incorrect Argument set
Hi, please can someone help on this formula? Program Site Range - A different sheet with multi drop down column sites Program Phase Range - A different sheet with single drop down column =COUNTIFS({Program Site Range}, CONTAINS($Metric@row, @cell), {Program Phase Range}, Justify$1) If I remove the Phase criteria, it works…
-
Create graph to show actual spend versus projected spend towards 100% complete
I have the information above and want to show a graph that indicates the health of the spend in a different colour in the same bar. My graph if I select the two neighbouring cells (in my case actual vs projected) then the vertical axis sums the values of the two cells and the bar column now shows an ever increasing bar…
-
Status light, nested IF statement
Hello everyone, I'm looking to find some help with my status light formula. My columns are as follows: • Date Due (date column) • Progress (drop down column with: "Not Started", "In Progress", "Complete" as options) • Status (drop down symbol column with "Red", "Yellow", Green", "Gray" circles -- to become a formula column…
-
Linking a Column to a masterfile with automatic updates
Hi Community I am creating a solution where I have linked a column on a sheet(Sheet 1) to a column in a 'masterdata' sheet using 'Link from Cell' function in Sheet 1 to the masterdata sheet. I want to be able to update the masterdata column ......and sheet1 to be automatically updated for any changes in the linked…
-
"IF" formula for a score range
Hello, I'm looking for some help with an IF formula to assign a text value in one column based on a score range from a different column. Thank you in advance for helping me figure out how to write this so that it works in the Smartsheet. --Lisa