-
SUMFIS btwn dates
I am scratching my head because this is a simple formula I have used in the past, but I cannot figure out why this is returning 0 when there are 2 values that should be summed in this period: =SUMIFS(Amount:Amount, Date:Date, <=DATE(2024, 6, 30), Date:Date, >DATE(2024, 3, 31))
-
Copy or Move rows to another sheet do not copy formulas
At the end of every sprint, I want to move data for this sprint to an archive sheet. When I move or copy rows to another sheet, the cell formulas are not getting copied. Only the values (without formulas and cross-sheet references) are getting copied. I tried the automation option and manual copy/move. But none of these…
-
How to Assign Contacts in Rotation?
Hi! I'm currently creating a ticketing system where different types of tickets will be assigned to different technicians. I have automations set up for most of the ticketing types, but two types (Radios and Support Request) need to be rotated between two technicians. How can I accomplish this?
-
Sending to contacts in a cell - How to limit who is contacted
I have an automated workflow that triggers an approval request once a form is submitted. The workflow is set up to alert contacts in a cell when the request is submitted. The contact list that would be alerted is the request approver. The approver is just one person from a list of approvers; I have another workflow set up…
-
Link from a cell-reference and make the answer a column formula
When we set up a sheet we did not add an 'industry' column. I can link to a metadata sheet to get that information and link it to a single cell on my sheet . . . however, I need to have that value appear on every line of a column (so that reports across with the info across industries can be sliced differently). I created…
-
Formula and Response Question
I need a formula based off of two columns. Date Created and the Date Reported. I am trying to determine if individuals are submitting documents within 24 hours. If they are in another column it should populate "Compliant". But it seems to be working for some but not others and the dates are sometimes the exact same date.…
-
Formula
Hi all, I am trying to combine the following two formulas, only one works at a time. =IF([Variance (Target End date)]@row = 0, "Green", IF([Variance (Target End date)]@row <= -4, "Red", IF(OR([Variance (Target End date)]@row = -1, [Variance (Target End date)]@row = -2, [Variance (Target End date)]@row = -3), "Yellow",…
-
IF(ISDATE) not working?
I have "Column B" that pulls in a date from another sheet. And I have "Column A" that changes to Complete when that date populates into Column B. In addition, I have a criteria for which it should say "Eligible", "Not Yet Eligible", or "Missed". This formula has been working just fine for a while. I have been updating a…
-
WEEKNUMBER formula
Hello, I am trying to count the number of weeks between two dates. I have applied this formula =WEEKNUMBER([SD End]@row - WEEKNUMBER([SD Start]@row)) It doesn't seem to be calculating correctly. For example, returning "51" for a SD End date 2/3/23 - SD Start 11/14/22. That answer should be more like 11, right? What am I…
-
Need help with Countif date formula
I have a date column, and I want to count the number of "Good Rolls" for that specific date. I managed to get Shift LBS Produced for the 24th and Total Rolls. The number 81 in good rolls column reflects the total for all date. How do I get a result for just the 24th, 25th etc.
