Formulas
Discussion List
- I have a sheet where I am using red, yellow, green and gray balls to indicate project health. If the project is complete, the ball is gray. If the due-date is within the next 14 days, yellow. If due-d…
- I'm using an Index match to pull a certain number. In this column I will get a successful return of a few number then the Error then more correct numbers. Thing is, they are all pulling from the same …
- When using the COUNTIFS formula and referencing the created (date) column in another sheet, what date / time format do I need to use when including a specific date as criterion?
- I have a formula that is working in most of the cells. However the number is not showing and the formula is in the cell. I am not sure as to why it is not showing up with a value. Here is a copy of th…
- I am using SUM referencing a column on another sheet and I want to get that column to be Open-Ended (so that when new rows are added to the other sheet, they will be automatically be in the new total …
- I am trying to get this formula to work correctly in final calculations of a project we are working on. =IF([Column3]2="","",IF([Column17]2="",CONCATENATE("it's been ",TODAY()-[Column5]2," days"),IF([…
- Hi, Please need your help on the below formula. As you can see on the image below, the stage column is set up as a dropdown list. I wanted to get a formula that says, if the project owner decided to c…
- I want to create an IF condition where if a cell contains a symbol on another sheet that equals "New" then populate that value otherwise, leave it blank. I have this formula: =IF({New Applicant(s) Ran…
- Hey all I need some help with tracking the latest changes in a row for my sheet. My sheet is going to have repeating update requests to track each shifts production levels every couple hours. The team…
- I'm trying to update my "At Risk" column (Flag icon ON/OFF). I want to create a nested formula. I want the flag ON if all three conditions are met: * The "Due Date" is within one day. Example: if toda…
