-
Formula Check Box
Hi There, I need help with implementing "Checked" vs "unchecked" symbol into my formula. Online I saw " Checked" and "Unchecked" and that didn't work for me. My formula : =IF([Founder?]@row = "", [First Name]@row + " " + [Last Name]@row + " is a founder of " + [Name of Company]@row + ".", IF([Founder?]@row = "", [First…
-
Quick SUMIFS question - Additional Criteria is Date
Hello, I have a quick question for the formula gurus. I have two sheets, a Roster and Data sheet. My roster sheet is where I want to show the data and the Data sheet is just a collection form. My goal is to display a point total that only pulls points from the last two weeks (14 days). So this is my data sheet. As we can…
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
-
SUMIFS with date range formula question
Greetings, I'm attempting to sum the number of project management hours for the project managers in my function for given points in time to generate a capacity forecast for 2024. I'm currently building a sheet to depict capacity every 2 weeks based on if a date falls between project start and end that will be built off a…
-
Tracking that updates are received from employees
I have created a sheet for employees to provide numeric updates at 10AM, 2PM, and EOD. On a separate sheet, I am trying to create an automatic checklist to ensure all updates are received and that will send reminders if their update is missing. My checklist looks like this: I have used this formula on a checklist for just…
-
Count If AND
Hi! I am trying to build a formula in which I can count an item from a list as long as it meets 2 criteria: 1- Item submission is in JANUARY 2- A dropdown selection is "No" I truly cannot wrap my head around making the right formula so it gives me the appropriate result as I do not know how to build a count IF formula that…
-
Calculate Avg # of Days project open - by person
Hi all - I need to create a formula that displays the average number of days a project is open, filtered by person. If this was a report it would filter all rows by person then calculate the average from there. How would you approach this? Seems simple but it's not working for me. Thanks!
-
How To create a revenue summary formula
How can I create a formula where by I have rows containing different projects, their value and the dates they will start and end and create a summary to show in what months will generate what value (assuming the value is divided equally over however many months the project spans) i.e. Row 1 is Project X with a value of…
-
Display formula result in form
Hi, I have a column formula that grab a link from reference sheet and I need this to be displayed before submitting the form. Example, column A is a drop down of items, each of these items can be downloaded from a shared link. So in column B I added a formula to grab the link from referenced table. However in the form I…
-
Building a sheet to best populate dashboards
Do you have any training material you can share on “best practices” for building a project plan/timeline to populate Dashboards correctly (e.g. metrics and tables). Examples of things I want to do: Present the overall project health as red, yellow, green; sum of late tasks; sum of tasks in progress and on-track; sum of…