-
Automate the selection of values from a Multi-Select Dropdown
Good day I am trying to select values from a Multi-Select Dropdown by using an IF formula. Is this possible? I dont want to manually have to select the applicable values from the multi-select dropdown selection, but instead the formula should select the multiple values in the dropdown. Regards, Pierre
-
Need help with COUNTIFS and DATES for Daily Cumulative Results - existing content does not help me
Need help with COUNTIFS and DATES for Daily Cumulative Results--less than equal to each day). I have 2 SSs (1 open, 1 closed calls). Couldn't get the formula right to pull from two sheets so I created grid for individual sheet results then total/SUM. Info will be used for Dashboard. Need to look at system date column and…
-
I would like a formula to tell me the number of days holiday taken this month
I have searched for a formula to calculate the number of days holiday, but I would like it to be more specific to tell me the number of days taken this month. So far I have this: =SUMIFS(Duration:Duration, Absence:Absence, "holiday", Assigned:Assigned, "Fred") which tells me the number of days holiday, total. But I need to…
-
Multiply Part of an Equation
Hi there, I have this formula (below) which works but I would like to multiply only the reoccurring hours of work to complete by 3 (second half of the formula). When I try to do it I get invalid operation. Any help would be greatly appreciated :). =SUMIF([Due in 3 Months]:[Due in 3 Months], 1, [Hours of Work To…
-
Can i have the AVG(collect) formula in the same column as the range that I want to Average?
I want to average the % complete column. I am writing the formula i the top row of this column and it doesn't allow me to do it. also, doesn't allow me to select any column from the same sheet. Am I missing something here? How can I solve this?
-
Responding to form submissions
I'm setting up a form for non-licensed users (requestors) to submit inquiries regarding the status of our projects. I have the form set up so that my team can provide a response to the inquiry within the form when they receive a notification that a new request has been submitted. How do I automate getting that response…
-
Countifs Contains part with an identifier
Hello, I'm trying to create a formula to count how many stores we have for a certain date based on the nomenclature of the store name. I want to count stores that start with "W" example W001234 or W004566. I also want to count stores that start with "R" Example RC00254 or RA00255 I had =countifs(Date:Date, =4/12/20),…
-
Calculation of monthly duration
Hi All, I've been trying to find a formula to automatically calculate duration in months from start date and end date. I went through several threads here but none of them seems to fit at all. Could any of you advise? I presume it is something in terms of =[End Date]@row - [Start Date]@row, unfortunately this shows me…
-
today() function change dynamically in sheet
Using today() function in sheet, so date will change dynamically or when we access sheet then it will change.. For example, if someone took the above actions on Apr 3rd and then no one takes above actions in Apr 4~ Apr 6th, then the today will remain as Apr 3rd.
-
Formula help
@Paul Newcome Reaching out for help again. How would you create an equation where the parent status is automatically updated when the child row statuses are changed. See attached picture. When all of the "Actuals" are "Completed" then change the parent status to Completed, if any of the "Actuals" have started, changing the…