-
Index(Collect Across 8 Sheets
This discussion was created from comments split from: Using a nested IF to determine a range.
-
INDEX (COLLECT) Formula returning #INVALID VALUE Error
I am trying to use INDEX COLLECT to pull data out of a specific column from another sheet based one three criteria. My formula is: =INDEX(COLLECT({Site Visit Intake - DOM Review %}, {Site Intake FDC-FW}, FW@row, {Site Visit Intake - DC}, DC@row, {Site Visit Intake - Metric}, [Metric Being Evaluated]@row),1) I keep gettingβ¦
-
Show Balance in a formula for all the column
I need to make a formula to show the balance in the entire column, but the formula column do not works properly. I have doposit, cost and balance. Deposit (sum), cost (diference), balance is the deposit less cost and the next row is balance plus doposit less cost and show the new balance. We need to copy when my rows fillβ¦
-
Combining Countifs & Distinct Formula
I am trying to combine countifs & distinct formula together but not having any luck. I need to get the count of requirements to 1 workshop (so many to 1). This means there are duplicates which I cannot count. Below is the formula I have tried just not having luck =COUNTIF(DISTINCT({Business Requirement Document Rangeβ¦
-
How to write formula to display health based on baseline variance
Hello! I'm trying to write a formula that looks at the baseline variance and displays the health status based on greater than - less than criteria. We need the formula to read if variance is greater than or equal to "0", "green", if the variance is less than 0 but more than or equal to -9, "yellow" and finally if theβ¦
-
Trying to flag an item within a date range.
I am using the Asset Management template set and need to have the dashboard update when an item is due within 7 days of the assigned due date. I tried the below formula: =COUNTIF({Sheet - Asset Tracker Range 2}, TODAY() + 7) Asset Tracker Range 2 is the assigned due date. This is giving me everything due exactly 7 daysβ¦
-
How to count days, stop counting, then continue counting from where it left off
Hi, I am working on a sheet to track parts that are waiting on different departments, such as Engineering, Debug, Materials etc. I want to have a drop down box or separate tick boxes if a drop down wouldn't work that would start counting days the part has been on that department. For example, Part 1 is selected asβ¦
-
Value for Criteria met
I am VERY unfamiliar with Smartsheet and trying to get acquainted.... I keep getting stuck. I need help gathering values for the sheet summary. I hope to use this platform in our office, however I need assistance in this before I can sell it. If there is a checkmark in "Date Contracted" but NO DATE in "Date Closed" I needβ¦
-
Return a value based on multiple cells
Hi, I want to check a series of cells and return a value of one cell based upon the others not being blank. If I have columns: Original Current Updated Actual Most Accurate I want to populate "Most Accurate" with the value in Actual. If Actual is blank then I want to pull "Updated" cell value If Updated is blank then pullβ¦
-
Can I combine two COUNTIFS formulas if there is a Date Range?
I use this formula to identify how many Requests a certain Division entered. =COUNTIFS({Divisions}, [Request Entered by]@row, {Request Type}, "Template Request") I want to combine it with this formula to identify how many times a month, does that certain division enter specific request. =COUNTIFS({Request Entered Date},β¦