Formulas
Discussion List
- I've searched how to clean up reference sheet labels within a task sheet when creating formulas, and I can't seem to find anything. It gets unruly when I'm creating formulas in multiple columns. Thank…
- Hello, I'm trying to set up my spreadsheet in a way that I can have a column that calculates the expected percentage of an activity for the current day based on the start date and end date. The formul…
- Hello everyone, I have three date columns with individual dates. In a fourth column, I want to display the next upcoming date which is not in the past. In Excel, I would have used something like this:…
- Hello, I am trying to "suggest" a contact in a contact list column but can't find a way to automatically populate a cell while still having the ability to overwrite it later if that suggestion is not …
- I'm working on a sheet that logs employee FTE changes across various grants. Over time, one employee might accumulate several changes across different grants. The sheet columns are as follows: Employe…
- Hello everyone, I have a sheet that summarizes the data across our portfolio. There are three columns I want to use in my COUNTIFS function: Core Assignment, SLT Flag, Status. I want to count all the …
- Okay, let's start out by saying I am so stuck I have no clue on how to create this formula! LOL Okay the formulas will be added to the PA - CAPA List sheet. The Training Report is the data source. Thi…
- I’m trying to work out a formula to calculate how many assets were created in the previous week from another sheet. I’m using a Week Commencing date which is the first Monday of each week and entries …
- Hi! I have a task tracker in which things are marked "Complete" from a dropdown and then checked off. The checkbox has conditional formatting that puts a slash through the entire row. Some of these ta…
- As you can see I want the formula to return a blank if there is an error but it's still returning "#BLOCKED"