-
How to calculate difference of two sheets into a separate grid
I have data in four grids; a master (G1) and three data sets (G2, G3, G4). I need to return the data results of G2 minus G3 as a line item in G1 but will require a "vlookup" to do so. Separately, I need to know if there is a difference "Yes/No" between G4 and G3 on the same line but in a different column. I've included a…
-
Return a date
I am sure this is simple, but I am relatively new to SS. I have 2 sheets, Sheet 1 is called FMS Columns are PN Sup FFM MTA Priority Promise Sheet 2 is called SS DATA Columns are PN DESC Need On SS ETA In sheet 2, I want to return a date only from sheet 1 that is in the promise column, when PN matches. And if there is no…
-
Looking for Formula where count of distinct PO #s in a given PO month
I'm looking for a formula, where need count of unique PO # falls in a month. In this formula, I used specefic PO # i.,e "123" but I need count of all PO # falls in a given month (See the screen shot attached) =COUNTIFS([PO Date]:[PO Date], IFERROR(MONTH(@cell), 0) = MONTH(Date12), [PO Date]:[PO Date], IFERROR(YEAR(@cell),…
-
Conditional Formatting Referencing Other Sheets
Hello, I'm building a process and want to add some automations to minimize errors. I have a column for "partner" that is a filled in via a form on sheet 1. I have a list of partners that we do not work with in sheet 2. I would like for the row (or cell) in sheet 1 to change colors if the form response is one of the names…
-
Formula to add days, adds years instead
Trying to add days to a date from another column on the same sheet, but it adds digits to the years format instead. Date Source = 08/12/22. Cell Formula =Date@row + 20 Expected Answer = 09/09/22. Actual Answer = 08/22/2220. Please assist and advise. Thanks.
-
Network Days Remaining Until Due Date
With this formula for the "Days Remaining Until Due Date," it should be "0" when the due date is today and it should be "-1" when it is only one day past the due date. =IF(ISBLANK([Returned To]@row), NETWORKDAYS(TODAY(), [Date Due]@row), "Complete") Can someone let me how to fix it or if there is an inherent error built…
-
Make symbols turn Gray if date is in the past but only if that column had an entry
I have a selection of vehicles that have the below formula which will insert the red symbol if they are listed in the corresponding column: =IF([日付 Date]@row < TODAY(), "Gray", IF(CONTAINS("4号室 Room 4", [問題報告RV東照明 Reporting Issue RVE Lighting]:[問題報告RV東照明 Reporting Issue RVE Lighting]), "Red")) What I need to know is how to…
-
Sheet Owner Name Auto-Populate in Cell
Is there a function to automatically pull in a Sheet Owner name into a cell? Thanks!
-
Looking to set a Date Field based on contents of another field.
We have a sheet with a list field identifying the target fiscal year and quarter that we want an activity to start eg. FY 23 Q1, FY 23 Q2 etc. This sheet also has been set up to work as a Gantt view with Start, Finish, and Duration as well. I'd like to set the start date automatically based on the contents of the FY/Q…
-
Ancestor 2 to autofill with Ancestor 0 value in primary column
I am in the process of creating an assignment sheet for staff. There are a few goals in the sheet. Card View by associated projects (ideally be able to move them/reassign them with ease) Card View by staff member Grid View by department. Staff to add percentage of time projected to spend per project separated by cost…
