Sign in to join the conversation:
Hello,
I'm trying to sum numbers in a column a if the launch date is within the next 30 days. Thanks in advance for any help!
Try something along the lines of...
=SUMIFS([Column A]:[Column A], [Date Column]:[Date Column], AND(@cell >= TODAY(), @cell <= TODAY(30)))
It will sum column A if the date is between today and the next 30 days.
thank you!
Happy to help.
In my job as a scheduler a common question is "which of the predecessors for this activity is driving the date?" Currently I have to rely on my own knowledge of my schedules or, worst case, I have to look at every predecessor until I find the one I am looking for. Microsoft Project is nice because it has the "inspect"…
Hi! I am trying to create DVs from this sheet that will do the following: In this screenshot example - Elizabeth is the roadmap owner, but Deb is the Calendar invite owner. So in Elizabeth's DV, I still need her to be able to see this row, but not be able to edit the Calendar Update Complete column. In Deb's DV, I need her…
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
