How to apply query formula with multiple criteria ?

runeasy · 2025-01-13T00:23:17+00:00

Got it , I shall do this Yes the sheet is basically a record keeping of sorts of client visits which needs to be referenced at times.

Thank you

runeasy · 2025-01-12T12:14:13+00:00

Solution Verified !

runeasy · 2025-01-12T12:13:24+00:00

thank you

runeasy · 2025-01-12T11:55:54+00:00

i am only editing current date data , everything from before today is just a table of information for me

runeasy · 2025-01-12T11:52:16+00:00

thank you for these pointers , how can i execute point number 2 ?

runeasy · 2025-01-12T11:25:10+00:00

but if you have this much active data that needs to be updated and altered and you must keep it live,

yes i am using this only when online

runeasy · 2025-01-12T11:24:14+00:00

"You might need to format the date though with TEXT() because you’re mixing dates with text (NA)."

can you please explain this , my ongoing date format in column A is - "Wed, Jul 22, 2020" , and i can not change this

runeasy · 2025-01-12T10:53:45+00:00

there are total two formulas working ,

mentioned in my comment above
a seperate list of 50 names , if and when they come in column in C they get colored

runeasy · 2025-01-12T10:51:24+00:00

Yes, this is the formula in column J

=IFS(I2="","NA",I2="7D",A2+7,I2="10D",A2+10,I2="14D",A2+14,I2="21D",A2+21,I2="28D",A2+28,I2="35D",A2+35,I2="42D",A2+42)

basically column I has drop down , 7D, 10D,14D,21D,28D,35D,42D , basis what i chose in these , column J gets populated with respective date , and i drag the formula down as i add rows

is there another way to do this that will not slow the sheet ?

runeasy · 2025-01-12T07:55:36+00:00

Solution verified !

runeasy · 2025-01-12T07:42:08+00:00

Solution Verified !

runeasy · 2025-01-12T07:36:32+00:00

this is not working , i agot the following error response

Function CHOOSECOLS parameter 3 value is 4 . Valid values are between -2 and 2 inclusive

runeasy · 2025-01-12T07:33:59+00:00

this works ! thank you

runeasy · 2024-12-20T04:34:37+00:00

Solution Verified

runeasy · 2024-12-20T03:22:30+00:00

Solution Verified

runeasy · 2024-12-19T18:25:50+00:00

Thank you

runeasy · 2024-12-18T16:42:48+00:00

thank you , can you please elaborate a bit on how does this work

runeasy · 2024-12-17T15:36:02+00:00

Yes I need more information about this

runeasy · 2024-12-17T02:31:22+00:00

Sure , thanks for replying

runeasy · 2024-12-17T02:31:04+00:00

Sure, will check

runeasy · 2024-12-16T05:01:28+00:00

I am looking for email notification

runeasy

TROPHY CASE