-
Formula for counting days
Hi! I use the below forumla to count days between to columns that have dates. The issue is it is counting the as individual days which basicall adds a day to the count. I want a true count. Help? Dtes calculated 6/7/24 to 6/8/24 (to me this is one day) the formula gives me 2 =NETDAYS([Created Date]@row, [Date Backup Sent…
-
Calculate the number of days in the different application statuses
I want to measure the number of days an application stays in the different application statuses. For this purpose, I have set up automated workflows to record a date in the corresponding date columns for each status change. When a date field is blank, it either indicates that the application skipped that status, or it is…
-
Finding the earliest date from Children based on the status in other column
Hi all, I'm trying to find the earliest (Min) date from children based on the value in a different column. So if the value in Asset Status column is not "Completed", "Cancelled" or "On Hold", then consider those children and then find the earliest date(min) from them. The column where I'm trying to find the earliest date…
-
Formula for Duration using Start & End Date & Time?
Hello, I would like a formula to calculate Duration (in hours) using the Start Date, End Date, Start Time, and End Time. I would like to keep the Time in 12-Hour format if possible. Any formula suggestions? I tried using a formula without factoring in the Dates, but the Duration for those highlighted in yellow ended up…
-
How to get Join Collect formula to work
I have a sheet (picture attached) where I am trying to show all of the tasks dependent upon a certain task from being done. I want to sue a join Collect formula to list out all of the tasks referenced in the the predecessor column that match the row #. For example, in the picture, Row 70 would show the task "eComm Mezz…
-
Sum If & contains
Hi, Hoping for some help with a Sum IF formula. I would like to sum if from 'Sheet 2' Value based on Sheet 1 project code. I have tried the below formula utilising 'Contains' however it is returning 0 rather than sum of project 304. Sheet 1 Sheet 2 Any assistance would be appreciated
-
Help with formula again
Hello, Sorry that I have been away but the last discussion I had regarding a formula revison still does not work. I've simplified my field names below and provided an example of what I would like displayed for the compliance status. Scenario: If all 3 columns have check marks and the flag is blank, then compliant. If 0 or…
-
Getting the difference between a past date and today's date
I want to use the sheet summary to report how long a project has been put on hold. So I have the date that the project got put on hold, which is Aug 9, 2023. I want to automate the calaculation of how many days it has been at any given time. I've tried multiple formulas and none of them are working. Even typing in =TODAY()…
-
Remove duplicates based on Modified Date
Hi team, any suggestion is appreciated! I have 4 sheets: Sheets A-C: Individual project trackers Sheet D: Main project sheet What I need: Setting up a workflow that copies row updates in Sheets A-C over to the Main Sheet (Sheet D). This will ensure the Main Sheet includes all project statuses so I can report on them.…
-
Formulas to Calculate Dates/Duration
I manage an intake process and want to calculate the duration that an item is in each stage (there are 3 stages) I created 3 helper columns - Stage 1 Date, Stage 2 Date, and Stage 3 Date. I also created automation so that when an item reaches Stage 1, the date is recorded —- same with Stage 2 and 3. I need help on what…