Formulas
Discussion List
- I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone …
- Hello, I am experiencing the following issue: In a sheet I maintain my project data is, a single identifier for a completed activity is an entered date. If date is lacking in the respective column, ot…
- Within a sheet (call it "A") I used a formula referencing a different sheet (let's call it X). Later I deleted sheet "A". However I see an annoying "Used in formula from unknown sheet" in sheet X. Is …
- Hi I have a project risk and issues Log and want to pull through the top 5 risk and issues through to another sheet (based on risk score). The risk and issue Log have a text description (there is a ri…
- Building an employee hiring database (sheet 2) off our hired applicants sheet (Sheet 1). After typing an email address in the first column of the sheet 2 , it should populate 4 or 5 subsequent columns…
- Someone knows how to include weekends in a single row on one sheet and that all other rows include only work days? Thanks!
- Based on the below screenshots, I am looking for a formula to SUM the FEE column only if the Project Stage column is equal to "Paid". I feel I am close to solving the formula. Any suggestions will be …
- Is there any way to reference data in another sheet based on a cell's contents? I have inventories that have asset tags and associated serial numbers. I have a separate sheet for maintenance logging. …
- Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar col…
- Hello, As an example, In a cell, I am looking to count the total amount of "Completed" statuses that are in a specific column labeled "status" on one or more sheets and have it tied to a specific "Cat…