Formulas
Discussion List
- Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be abl…
- With this new feature I'm hoping I can eliminate abut 10 columns from one sheet and create a sheet just for totals. Currently I have several columns just for counting the value of columns with checkbo…
- I am trying to decide between one sheet vs multiple sheets. I currently have one sheet but it has over 50-60 columns and there are sets of data that will be used by different areas. I know I can filte…
- I am trying to COUNTIFS but have been unsuccessful so far. I need to count the status of a project if it is a certain product. I keep getting #INCORRECT =COUNTIFS(Status3:Status51, "Green", Product:Pr…
- Hi, I am very new to this an am getting a bit frustrated. I have the following columns, Ship Date, Fabric Order Date, Fabric ETA, and Fabric Received or In Stock. The first 3 columns are date columns …
- I am trying to ultimately set up my sheet to automatically send out Update Request 3 days (or whatever I set) within the "Bid Date" loaded into the sheet. It would be ideal if this update request woul…
- i need to activate a check box based on the following condition. if date cell A is less than or equal to Todays date and cell b and greater than or equal to todays date then check box. how do i write …
- I'm looking to make a formula that will do the following: search all instances in Column2 for "A" IF subsequent Column3 has a value of "YES"....if all "A"s = "YES" than return a value of "YES" otherwi…
- Here's a version of the formula that works. However I need to include a second value and get an error when I try. I'm sure it's the formula syntax. Not sure if there is a better way to get the right o…
- I've looked and cannot solve a problem I had solved before... I have a checkbox to denote when a task is completed. I have a due date. My problem is that I want my RYG to be green if the box is checke…
