-
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…
-
SUMIFS between date range formula not working
Hi All, I am trying to sum the total overtime hours cost for various roles on a project and I am breaking this down into weeks, so I need my formula to look at a range between 2 dates. My formula works correctly for some roles but not others. The OT hours information is collected via a smartsheet form which, amongst other…
-
Auto-number Column and MAX COLLECT with Criteria
Hey friends! I want to combine the two below operations into one column: I'd like to return the highest value in Auto-numbered column when the criteria is met from another column. ~Return the highest/largest auto-number, from the "Row ID | Auto-Numbered" column, matched with each ID# in the "⚠Mac ID#" column. Then, when…
