-
Please Formula for checkbox when two dates are entered.
Hello, I am trying to figure out the formula to make a 3rd column check once two dates are entered. Please and thank for you help Johanna
-
Can we set cell linking based on conditions
I looked into a few formulas to do this such as if statements however I need to use cell linking because the value can be managed on both sheets. So if it changed on sheet A I also need that to update on sheet B (I have both an inbound and outbound link in the cell so it will work bi-directionally). But with cell linkingโฆ
-
Order duplicates
Helloo! How to get order in the list of duplicates(1,2,3...) to after export each value to different colums For example: spain 90, spain 30, france 20ยก, france 22 italy 20 1 2 3 Spain 90 30 - France 20 22 - Italy 20 - - Anybody that can help me? Thank you in advance
-
fill cell from another cell
i have a spin off of the same question. column 1=date , column 2=mods number, 3=helper. Helper= =IF(mods522 = "", "mods empty", IF(date522 <> "", "date empty T", TODAY())). then i was trying to today's date in Date column from this cell. i tryied workflow to do this but they did not like it because you had to save andโฆ
-
I would like to create a N/A remark for the blank dates based on the grey status of an adjacent cell
Formula for OSHA-30 Status: =IF(ISBLANK([OSHA-30 Exp Date (10-yr)]@row), "Gray", IF([OSHA-30 Exp Date (10-yr)]@row - TODAY() > 75, "Green", IF([OSHA-30 Exp Date (10-yr)]@row < TODAY(), "Red", "Yellow"))) Formula for OSHA-30 Exp Date (10-yr): =[OSHA-30 Training Date]@row + 3650 Thank you!
-
Nested If/And Formula Not working
Hello All, I'm working on a project plan and want the status of the task to automatically appear as a color based on the following conditions: If % Complete = 1 (100%), then Blue If % Complete <1 and today => Finish (Date), Red If % Complete <.50 and today - 5 days is equal to or less than Finish, then Red. If % Completeโฆ
-
Hello All-
I need to be able to count how many rows are in a column but only if the received date is December. I'm getting and #Unparseable error when i try this out. Anyone have an idea why? =COUNTIF([Dealer Name]:[Dealer Name],[Date Received at Svc Center]:[Date Received at Svc Center] MONTH(@cell)=12)
-
Alphanumeric sorting issue - please help!
Hello, I have a primary column that starts with 21 for the year and then TMP for the type of advertisement. When someone submits an ad request, the default value to the sheet is 21TMPXXXX; however, we can no longer see the ads in numerical order since we reached 1000... the 900's end up all over the place...I would like toโฆ
-
Stop Accrual Formula
Hello, I need help creating a formula to stop the accrual process once a number of hours has been reached and then to begin the process again after hours have been used. My Columns are below so once the balance is 240 then stop hours earned and then once the balance is below 3.08hrs of 240 then resume accruing not sure ifโฆ
-
CountIFs Ignoring Blanks
Good Morning, I am trying to get this formula to work however I'm getting an Invalid Data type probably because in some instances there's a date but the duration hasn't been calculated yet. Essentially i would need it to ignore the cells that are blank in the duration column. Here's what I have: =COUNTIFS([Date Received atโฆ