-
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…
-
Is it possible to match multiple values with in a single cell?
I'm sorry if this is long winded. I am creating a workflow process where a file will need to be emailed to multiple users at different locations. There is a drop down that lists the locations, in this example it's 3 separate locations, Portland, Minnesota, and Houston. I'd like to keep this drop down to allow multiple…
-
SUMIFS with an either or condition
I'm struggling to make this work . . . . I'm starting with a SUMIFS that works: =SUMIFS({5_METRICS_SALES LEADS Current Year Goal}, {5_METRICS_SALES LEADS Today}, YEAR(@cell) = YEAR(Today@row), {5_METRICS_SALES LEADS Sales Lead}, VARIABLE@row) The 5_METRICS_SALES LEADS has two columns I want to sum (Current Year Goal and…
-
Check Box If "Due Date" is in the Past and Keep Box Unchecked If Not
Hello, I am wanting to use a simple formula that will check a box if the "due date" column is in the past while also keeping it uncheck if the date has not past. I am assuming I will use the IF formula, but not sure how to write this. Thank you, Ryan Holguin
