Hello - - I am trying to count the number rows in a column that do not have strikethrough applied to them. Is there anyway to use a formula to determine if a cell value has been formatted with striket…
Is it possible to import a spreadsheet (with a few sheets in it) which has Vlookup and other formulas? Doesnt anyone has done it? I have just signed in for a free trial... it looks like I have to do a…
Hello, I have pay dates on the 15th and the last day each month. A person may be contracted for say 21 days and that pay needs to be parsed out depending on what days that employee worked in that time…
I'm trying to use the below formula to calculate the amount of days between when a project is due, and when it was actually finished. Sometimes this will be earlier than the due date, sometimes after.…
I am trying to get a formula to do a COUNTIFS based on multiple criteria, but also that one of the date columns is greater then a specific date. The formula I'm currently using is: =COUNTIFS({BDDM}, "…
Hi All, How can you add a space between 2 vlookup functions? Here's the formula: =VLOOKUP(Alias247, {Pilot Data Base Range 4}, 3, false) + VLOOKUP(Alias247, {Pilot Data Base Range 4}, 2, false) This w…
Hi. Among the other columns i have 2 columns named "Task Name" and "Start Date". What i would like to create now, is whenever new line is entered to "Task Name", the current date will appear automatic…
I've brought this up before and at one point I thought that I found a great work-around. I would like to use calendar days in my date dalculations but, not have an end date land on a weekend. I create…
The rules feature is nice but it is very limited and only allows to change things from different fonts, colors, strikeouts, etc. I would like a rule that allowed more detailed changes. For example, if…
I have a text column that has formulas and conditional formatting already added to it preventing me from changing the column type to a dropdown list. It is spread across several years of spreadsheets …