-
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
-
Changing State Based on Criteria.
Hi all, I think I have some syntax incorrect in my code and hoping for some help. Currently, I have a formula that sets the State of a task based on % Complete: "=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))" I also have an…
-
RYG Status Balls Formula Help!!
I am looking for help developing a formula for the following RYG Status Balls Conditions: If status is "not started", grey If it is 1 day before "due date" and status is NOT "complete", yellow If it is the day of the "due date" or past "due date", red If status is "complete", or "in progress" and it is 2 days or more away…