-
Conditional formatting for entire sheet instead of columns?
I have a grid set up to track the status of 12 different steps in a process for 10 items. The rows list the individual items, the columns track the status for each step. I want the cells to light up based on the status - Not Started = grey, In Progress = yellow, Complete = green, Having Issues = red. Is there a way to do a…
-
Workday formula needs to reference one cell but it automatically changes
I have a workday formula in a date column which is supposed to reference one specific cell (row 1 of the the Last Workday of Prior Month column) but the formula automatically changes to row 3, row 4 when I try to apply it to the following rows. How do I make it stay on row 1? The purpose of this formula is to create a due…
-
Need Help Resolving #UNPARSEABLE Error in Date Formula for Invoice Month and Year
This discussion was created from comments split from: How do I return the name of the month in one cell if I only have a date (xx/xx/xx) in another cell?.
-
Looking for formula help on a date range plus one more item
Good Morning. Looking for help from folks that are far more savy than me. I have a schedule that I am trying to link to a metrics sheet so I can then report to a dashboard. Example below. I am trying to get the metrics sheet to calculate everything that contains "Real Estate Search Begin" and is in 2024. Would have a…
-
Math Logic Formula - IF THEN ELSE? Part II
I have an update to my original question below. I now want to take this formula =IF([Survey Calc]@row < 121000, 121000, IF([Survey Calc]@row > 3000000, 3000000, [Survey Calc]@row)) and change it a bit because I realize I forgot we have an additional option. I need to add a zero option: I need the formula to have an option…
-
Formula to add a # of days to a date to calculate ETA
I have a form that calculates a TAT based on the amount of material requested (1-2 items is 4 days, 2-5 is 6 days, etc etc). I also have a column that is a date only version of the time stamp, so the requester does not have to enter "Date of Request" inthe form, it defaults to the date of the request this way. What I want…
-
Conditional Formatting with Text Validation from List
I have a column that has different names in it [HANGERS]. I have a master list of names at the bottom of the sheet in a different column just floating at the bottom there out of the way. I do not want a dedicated column for this list if it isn't necessary. Range [BUILDING]623:[BUILDING]648. I want conditional formatting…
-
If blank, copy another field
I have the following columns: Start Date, End Date, Baseline Start Date, Baseline End Date, all of which start out as blank, are date type fields. Once a Start Date is populated, if the Baseline Start Date is blank, it should update with the Start Date Once the Baseline Start Date is populated, it should not change I would…
-
Calculating sum of Receipt Totals from another sheet based on criteria of 3 columns
Hello, I am trying to build a metrics sheet to put into my new dashboard. This workspace includes receipts/ invoices that have been submitted by employees. On the Metrics sheet, I have the following columns- Branch, Field Cost Center, Charge Account, Auto Code, Total (YTD). I am trying to pull the receipt totals from…
-
VLOOKUP/INDEX return client name from master
Hello - I am trying to create a dynamic dashboard where a client name can be changed based on need. I watched a video on YOUTUBE and it was very good but he was indexing on numbers. I need to match on latest name entered into form. I am not getting results, have tried VLOOKUP and INDEX. I now it is likely a simple mistake…
