[email protected]’s Profile

points
178

Hi,

I have a formula that looks for a specific word or variance of the word, is it possible to look for more than one word?

The formula i have is =COUNTIFS(Response1, FIND("shower", LOWER(@cell)) > 0)

This works for the word showers or shower which is perfect, however am i am able to count if the

Hi,

I have done a formula for Countifs

=COUNTIFS({July Range unders}, <0, {July Range Manager}, [A/M]1)

This works well and returns the correct data, however i now want the total sum of these entries so tried the following:

=SUMIFS({July Range unders}, <0, {July Range Manager}, [A/M]1)

But this is

Hi,

i have created a workspace which has some reports and other sheets on, this is all rolled up into a dashboard.

I have shared the workspace with colleagues, however when they click on a report it brings back a blank report with no data.

Hi, i am looking for some help please.

I have been reporting using today and looking back 30 days, however my business now wants me to report on the previous months data. so if in Mid June it looks at May's data

Is this possible to have as a formula?

Thank you

Dave

Hi,

I am working hard to get my head around formulas and have managed to get the correct return with the below formula, if greater than 14 days then return "Yes", if less than 14 days then return no. Where i am struggling is i also want to return "Yes" if the cell is blank.

current formula:

Hi,

I am looking for some help with a formula please?

I have a scheduled date which is static, Column name "1st Scheduled" i then have a completed date, Column name "Completed date"

I am trying to have the status column update to "Overdue" if no date is entered in the "Completed date" and today is

Hi,

I am trying to count the total in a range on another sheet if entries fall within a certain date range (30 days) and are a specific name "Missed Hours"

I have the following formula but cant get it to work:

=SUMIFS({Help Desk Range 1}, <=TODAY(), {Help Desk Range 1}, >=TODAY(-30), {Help Desk

Hi, i am looking for some help please.

I have a % complete column that i want to automate to 100% if a date in another column has a date in, but also return 0% if the date column is blank.

I feel this should be easy but am struggling and would appreciate any help.

Thank you as always

Hi I am trying to create a formula that count all entries by a certain person within the last 30 days. This is a cross sheet formula and seems to work well.

Now comes the however!

I have the below formula which does the calculation, however if a date is in the future it still counts it.

Hi All,

I have a sheet that has been populated via forms for the past 12 months. What i would like to do is use a count if formula but only when the date is this year.

my current formula is =COUNTIFS({Pure Gym Issue Type YTD}, "HR / Lateness or leaving early")

This works really well but counts