-
Need to count workdays too in the formula how can i do that?
=[Due Date]1 - TODAY() How can I make this formula in a way that it only counts working days and not Saturday and Sunday
-
Looking for help in getting a cell in a sheet to read "" or "TBD" instead of "#Invalid Data Type"
I'm using a sheet to consolidate the status and dates of several projects into a easy to read report. For several of my project sheets, I have a cell which will be reading "#Invalid Data Type" until all of the dates are added to their respected sheets and the formula can pull. What I'm hoping is that there is a way that I…
-
Formula Help
Good Morning All Wondering if someone could help me add and addition condition to this formula. I tried and keep getting an error back. I need to add if Program Status Type is NOT blank in the formula below. If the end date is less, then today and Status @row is not Complete and Program Status Type is not blank then check…
-
Is there a v lookup type formula that will find all tasks assigned to a specific person?
I am building a personal task tracker template for my team so everyone can better manage daily tasks as well ass see any tasks assigned to them as part of a project. Is there a formula or way to have project tasks automatically added to a sheet or report as they are created and assigned to a specific person?
-
=IF(CONTAINS... Syntax Error
Trying to figure out where I've gone wrong with my syntax... In a Total column I have the following '#Unparseable' formula =IF(CONTAINS(“Custom”, [Data-Pipe Type]@row), 4, 1) Help me see what I can't see please?
-
Vlookup referencing formula field
I have a text/number field which is populating by using the =Left formula. I then want to reference this field using a vlookup to another sheet and pull in the corresponding information. I keep getting the #UNPARSEABLE error, and I've determined it's due to formatting, but not sure how to fix. As an example, I have a…
-
Formula based on two column values
Hi, I am looking at doing a formula that looks at two columns and provides a # value based on what on the values that are in the two columns This is a simple formula that I am looking at, but it will only go two levels down and then stops. =IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 1, "1", IF([Urgency…
-
If Checked then $$$$
Can some one help me with a if checked formula we are doing an intake sheet for a vendor showcase and i want the amount to create a total approved by each vendor when they select each option to show so like if column 1 checked then $10 and add a sum formula at the end I hope this make sense
-
How can I average a percentage in a parent row?
I have a status column that uses Red, Yellow, Green and Gray to represent "Not Complete", "Partially Complete", "Complete" and "Not Applicable". I successfully added a progress column that uses a formula to translate those statuses into a percentage. However, since the parent row also has a status color, I can't get the…
-
how do I wright the =if for this
I have a call audit sheet were 12 questions total a percentage in a column call marks i now need the answer in mark to show fail pass or excellent. and highlighting as well if possible. 0 to 69 being fail (showing word and highlighted) 70 to 85 being pass (showing word and highlighted) 85 to 100 being excellent (showing…
