-
Help with Formula
I'm trying to help someone on my team. Below is a modified snap of the spreadsheet.. The desired outcome is to return the next date in line that is NOT CHECKED. For example, the "Current due date" for the first row would be 9/24/21...the second row would show 9/17/21. I've been working through the "If" statements but am…
-
Extracting a date from a text field
Ok, now... I have this data in one text column "2021-09-14 12:02:51" and I'm tryng to extract the date only (i.e. 2021-09-14) from this data and have it stored in a DATE column in the same sheet. I've tried many different ways but just can't make it work... I'm getting frustrated ;)
-
Can a Contact column populate based on selection in another cell?
I have two columns; Workstream and Workstream Leader. Their column types are Dropdown (Single Select), and Contact List respectively and each contains five available selections and are set to Restrict to list values only. I want the Workstream Leader column to populate with the contact that I know to be responsible for…
-
Countifs on a column that is a multi-select drop down..
I am trying to do a countif and one of the fields is a multi-select drop down and isn't returning the correct value, no idea what to do R4+ BP007 Change Inventory Range 1 is the field that is the multi-select column. =COUNTIFS({Status}, =[01 Open]$1, {Primary Function}, =$[Primary Column]5, {Fit/Gap}, ="Gap (Core…
-
If Formula with a Dropdown List
I have a column titled Status that includes the following drop down selections: Not Started, In Progress, On Hold and Complete. I want to write a formula that based on the drop down selected, another row would populate the following automatically: Not Started = 0%, In Progress = 50%, Completed = 100% and On Hold = ON HOLD.…
-
Formula for several "If/Then" support
Hello Community! I have tried googling this for excel and I'm just not getting my formula to calculate what I want/need. I've created formula for equating a number range to a letter, but I can’t figure out how to get the letter cell to not populate if nothing is entered for a numerical value (left blank). I don't want to…
-
Last 30 days range
Hello, I have looked through the forums that are currently open and could not find a formula that would fit my current needs. I am using the following formula now: =COUNTIFS({Pre Trip Completed}, <3, {System}, "ITCMW", {JBO Type}, "Overhead", {Date}, IFERROR(MONTH(@cell), "") = 8) This formula is pulling data by month (8=…
-
COUNTIFS with date referencing a date range
Hey all, I have a time off tracker for our installers and their skillset is either level 1,2,3 (picture 1). I need a way to show who is taking off in reference to the date column by level (picture 2) but not sure how to build this formula with a date range. Also, I have it set where if they request one day off, the "End…
-
Project Phases of Development
Hello! I am trying to find a way to show the development stage of a project so it can be rolled into a report. Basically if all of the tasks in a section are complete, then the development stage would be the name of the next header task. For example (see image), if "Project Planning," "Drafting," and "Developing" are all…
-
Cross-Sheet Formula Help
Hello, I'm trying to create a cross sheet formula that looks at the content of multiple columns in a row on one sheet and looks to another sheet to confirm those values are present, and then returns a value in that sheet. I've tried VLOOKUP and an IF statement, but I'm not able to get it to work properly. FYI - within each…