-
Date Formula Issue
=DATE((YEAR[Tactical Training Start]@row), (MONTH[Tactical Training Start]@row) + 1, (DAY[Tactical Training Start]@row)) ^^ This is the formula as it sits now. I'm trying to take the date from the Tactical Training Start column for a cell and add 1 month to the date for a different cell. What am I doing wrong?
-
Need Help with formula: Join(Collect
I am trying to look up multiple criteria (VENDOR PO), (SAP LINE#) referenced in another sheet and return (CPSD) if it matches the criteria. current formula below I need to edit the highlighted in yellow so it looks up the vendor name and then matches the (VENDOR PO) and (SAP LINE#) to return the (CPSD) Below is where my…
-
Actual vs target Date
Hi, Need a help if my Start Date is 05/24/2021 and end date is 07/01/2021 and in my project plan sheet say i have a task that start on 06/24/2021 and end on 06/28/2021 .However, that task is already been completed and the actual % Complete has been updated to 60% for that task i want the schedule Health should be turn to…
-
Using INDEX function with Multi Select Columns
Greetings, I have been poking at this for a few weeks now, and I can't imagine that this is as complicated as I am making it. Below is an overly basic version of what I need to build. The left (tan) columns represent a sheet that managers update to request eLearning for their units (Care-Areas) and the right (blue) columns…
-
How to split text to support reporting?
Hi, I am bumping into a design / Smartsheet limitation issue. I use an request inventory sheet to track client change requests. CR are submitted via a form. One of the field helps tracking the category of the CR (business feature grouper). I had to concatenate 2 types of data to workaround the form and the fact that I…
-
Using COUNTIFS and NOT together
I am using the following formula and getting an error: =COUNTIFS({Master Discrepancy Log 2021 Owner}, $[Primary Column]@row, {Master Discrepancy Log 2021 Product Type}, "Prime Share", {Master Discrepancy Log 2021 Month Opened}, 2, {Master Discrepancy Log 2021 Year Opened}, 2021, {Master Discrepancy Log 2021 Discrepancy…
-
How to return specific Column from a Multi Column Cross Sheet Range
Hi Folks, I have the following formula used to track specific assets: =SUMIF({EventDate_req}, $DateNeeded$1, {Asset2_Range}) This adds up the count in each row in the Asset2_Range that matches the date needed. We created individual one column ranges for each asset (Asset1, Asset2, Asset3) etc. Problem is we are using too…
-
Most Occurring Value Based on Multiple Criteria
Our organization is counting how often we interact with clients weekly and that process is going great. What I want to do is show who contacted the most clients during a particular week. We have a data dump master sheet and a sheet where I consolidate some high level data. With this one I don't even know where to start…
-
#INVALID OPERATION is trying to break me
This formula is wrecking my day so I am waving the white flag and asking for help... I am attempting to display the LOG 2 "Title Company" where the LOG 1 FC Start Date (020) .GT/ET. the LOG 2 "Effective Date" and LOG 1 FC Start Date (020) .LT/ET. the LOG 2 "End Date" and LOG 1 "Property State" = LOG 2 "Property State".…
-
Change Past Date into Month as Written Text
Probably a simply question but I'm looking for a formula that is able to read dates in the past, and then fill a different cell with the month as text only. e.g. The first 'offline' date would populate the offline month with 'October' Thanks