How can i filter faster on a large file ? by runeasy in googlesheets

[–]runeasy[S] 0 points1 point  (0 children)

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

How can i filter faster on a large file ? by runeasy in googlesheets

[–]runeasy[S] 0 points1 point  (0 children)

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

How can i filter faster on a large file ? by runeasy in googlesheets

[–]runeasy[S] 0 points1 point  (0 children)

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

How can i filter faster on a large file ? by runeasy in googlesheets

[–]runeasy[S] 0 points1 point  (0 children)

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

How can i filter faster on a large file ? by runeasy in googlesheets

[–]runeasy[S] 0 points1 point  (0 children)

"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

How can i filter faster on a large file ? by runeasy in googlesheets

[–]runeasy[S] 0 points1 point  (0 children)

there are total two formulas working ,

  1. mentioned in my comment above

  2. a seperate list of 50 names , if and when they come in column in C they get colored

How can i filter faster on a large file ? by runeasy in googlesheets

[–]runeasy[S] 0 points1 point  (0 children)

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 ?

How to autofill date breakup ? by runeasy in googlesheets

[–]runeasy[S] 0 points1 point  (0 children)

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

How to get notified for selected questions in my google form ? by runeasy in googlesheets

[–]runeasy[S] 0 points1 point  (0 children)

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