-
Does the INDEX / MATCH formula have to match exactly?
Can I use INDEX / MATCH for partial matches?
-
Turn Date Red
I am looking to turn the date red if past due + 7 days. Conditional formatting is not working. Does anyone have the formula to make this work? See screenshot below
-
Is there a way to create a WBS formula that produces only whole numbers
I need a WBS formula that produces numbers that will be nothing more than 1, 2, 3,.... 878, 879, etc., regardless of indents and outdents. I don't want, for example, "1.2.13.5" Is this possible? The reason I ask for a WBS-like solution is because if I rearrange the rows, I want the calculation to adjust accordingly. So if…
-
Current Week
I'm working on a project where I need to identify Current Week and Last Week. In the below screenshot 08/28/22 is a Sunday (1). 08/28 - 08/31 should show as Current Week but 08/28 shows as Last Week. I've tried to change several things but can not get Sunday to become part of the current week. Any thoughts on what I doing…
-
How to extract the Row # digits from the Predecessor column
Here are some samples of what I have... 19FS -2d (I want to extract "19") 17SS (I want to extract "17") 762SS, 22FF (I want to extract "76" to one cell and "22" to another cell) Any ideas?
-
SUM & SUMIFS
I have columns named: Item Description (That contains within a text (Z123) Quantity Received (Check Box) Not sure if you can use SUM and SUMIFS in same formula Looking for a result of ~~ Out of a total of (NUMBER) you have received(NUMBER). Thanks!
-
IFS & COUNTIFS/ MATCH, NO MATCH
Below is a screenshot of my sheet. I have count if, Match referencing another sheet with this sheet. Individual columns will show " MATCH"- ( DATE MATCH TEST 2022:Invoice Date) (Payee:PAYEE TEST MATCH 2022) But the COUNTIFS IN the (2022) Column matching payee & date is returning NO Match. The data is clean in both sheets,…
-
Hierarchy Drill Through Solutions?
I feed my sheets into Power BI (pre-formatted gantts) and I need to create a way to drill down through levels of a sheet's hierarchy. Ideally, at least 4 levels of the hierarchy, Great Grand Parent, Grand Parent, Parent, Child, if you will. I'd like to mimic the concept that's in MS Project, on the View tab, Data group,…
-
Need help combining IF, AND/OR formulas
Hey yall! I am trying to write a formula that will read the 'Check In' column and "Last Wk Check In' column and check the '2 Wk - No Check In' flag if the following cases occur: If both columns read 'No Check In' (that flag is currently working as can be seen in the screenshot below) If the columns both read "No Data', I…
-
Whats the most reliable way to automate data collection by student/client name?
I'm pretty new to Smartsheet and I have a pretty big set of data for each one of my 60-80 students I am trying to use it to track. I manage a therapy department at a special ed school. I have two sheets one that gets raw data from a form filled out by multiple therapists for between 60-80 different students and another…