-
VLOOKUP or INDEX MATCH Referencing Another Sheet
I would like to pull "Type" from a different sheet by matching the Project #. I've used both INDEX MATCH and VLOOKUP formulas which has worked well! Here are the formulas: =INDEX({Program Intake Form Range 1}, MATCH([Project #]#, {Program Intake Form Range 2}, 0)) =VLOOKUP([Project #]#, {Program Intake Form Range 2}, 5,…
-
Return "Yes" if a date range includes a certain month
I am trying to return either a "Yes" or "No" value in columns for the months of the year if a date range for a project or activity has dates in that month. For example, if a project starts on 2/15/2022 and ends 4/15/2022, I would want to have "Yes" in the February, March, and April columns and "No" in all other month…
-
Formula to find time between two times
I have two columns with times in them and I am trying to find the time between. Scheduled start time vs actual start time. I'm at a loss.
-
Formula Help With Date Range look back
I have a sheet that I am to trying to get a count based on specific response in a column and be based on completion in the last 30 days.
-
How to add duration (in days) in the duration column using formula?
I have planned duration and actual duration columns for project task activities. In trying to add the duration (in days - i.e. 1d, 3d, 30d etc) for the project tasks in the duration column using e.g. =SUM ([Actual Duration]:[Actual Duration]), the adding of duration does not work. I believe only numbers can be added. How…
-
Secondary Logic in Forms
Does anyone know if there is a way to use secondary logic in forms? Basically we are trying to have three drop downs, first is the supervisor where they go in and select their name, once they select their name we want the next drop down to only include their employees, and then the third is approve or deny. So far all I…
-
Formula using a checkbox column to get Yes/No
Greetings, I'm trying to write a formula that will give me a yes or no in a new column when criteria is meet. For example, if in Services Needed column contains HVAC, Lock/Unlock, Lighting Only AND HVAC Completed, Lock/Unlock Completed, Lighting Only Completed are all checked then it will equal Yes in all services done?…
-
Display column name in a cell if checkbox is checked
I am tracking the status of multiple deliverables (rows 2-7) using checkboxes in multiple columns (8 in total) with the column name describing what status level the deliverable is currently in. I want a reference cell per row that displays the column name of the column who’s checkbox is currently checked. I have the…
-
Calendar App Toolbar and Adding Recurring Meetings to the Calendar
Looking at some video's on using the Calendar App in some there shows a Calendar App toolbar on the left side of the screen, how can I get that added to mine? Also is there a way to setup meeting using the Calendar App with meetings that reoccur? i.e. Every other week, weekly on the same day etc. I'm looking to try and…
-
Which Formula To Use to Return a Value from Another Sheet with Multiple Criteria
I have a sheet in which I'm trying to create a formula to return a value from another sheet, based on an input in another column. I have successfully used VLOOKUP to accomplish this using one criteria, however, there are multiple criteria options. Meaning, depending on the name input into the "Card Holder Name" column, I…