-
Automated Workflow for Linked Cell Copying
I am trying to create a workflow that, when a new row is created, will copy over to another sheet. Also, when that row is updated, I would like for the changes to be automatically reflected in the second sheet. Right now, I have to link these manually, but would prefer to set up the linking in the workflow directly. Is…
-
Create a "Last edited by [Name] [Date] [Time]" object for Dashboard
Our dashboard data sheets as well as the dashboard itself are updated frequently and we would like a "Last edited by [Name] [Date] [Time]" object at the top of the sheet, which were are currently doing manually. See screenshot. Would like this to happen automagically whenever a user saves the dashboard.
-
How to create a formula that indicates duplicates
Can someone give me guidance or instructions on the best way to do a formula that would indicate duplicate reqs. on our onboarding tracker? This is what I'm looking to do "new checkbox column and write the formula to check the box whenever there was a duplicate and then added a conditional formatting rule to highlight the…
-
Is it possilble to use a calculated row reference in a formula?
I have a table (2x12) of data (sales $) for each month (one row per month) in the Current Year(CY) and Previous Year (PY) columns. I'm trying to calculate the YTD sales (by month) of CY and PY based on today's date using the function, Today(). I know I can use a formula like PY-YTD = SUM(PY1:PY4) to sum the first four rows…
-
Checkbox cross referencing person on another sheet
I am looking for a formula to cross check another sheet to check a box on my cumulative sheet. Example, someone completes a required training on EM# 1 sheet then on the EM# 2 sheet I want that persons name to be checked from a list of other individuals. This is the formula I used, =IF({Emergency Preparedness Employee…
-
Is there a way to have a date change in autofill within a formula?
I am looking to shift the way my data is displayed so I can place it in a dashboard. To do this, I'd like to shift the information within to do a specific date and return that. My formula works fine, but I have to change the date for every single line. Wondering if there's a shortcut or something that I could do to avoid…
-
Summary Formula to Show New Value Each Day
I have a sheet that tracks new employees by type. Within my sheet, I have a date column and employee type columns (example: Intern). I'd like to create a Summary formula within the sheet that will return the number of interns each day. Or a formula that will return the last entry in that column. How can I do that?
-
Formula with using three separate columns
I am trying to write a formula that counts the number of PINS Case_FRB based on Force Level_FRB and within a specific date range. I'm using the formula below, but it is not working. =COUNTIFS([Date Presented to FRB]1:[Date Presented to FRB]205, AND(@cell >= DATE(2021, 2, 1), @cell <= DATE(2021, 5, 5)), [Force…
-
Counting Children on Multiple Criteria
Hi all I am using the following formula in a parent row which has 10 child rows: =IF(COUNTIF(CHILDREN(), "Complete") < 10, "Not Done", "Done") It shows Done as soon as all the children rows have the word Complete in them. Now I want this formula to favor 2 conditions for "value_if_true" part of the "IF" function: if all…
-
Cross Reference Countif Formula is giving Unparsable Error.
I am hoping someone can help with Countifs formula referencing another sheet. The current formula that I have works great on the master sheet. =COUNTIFS([Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1), [Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31)) However, when I modify on another sheet to read as what is…
