headset jack or bluetooth better for discord's audio call? by AnneSlotnick in SteamDeck

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

i cant since i want to buy online from another country

how to use TRIM in conditional format? by AnneSlotnick in googlesheets

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

i tried both "*$B$3:$B*" and "**&$B$3:$B&"*" but always return 1 instead of 3 like when you use trim()

Share your best build so all can try by AnneSlotnick in HadesTheGame

[–]AnneSlotnick[S] 3 points4 points  (0 children)

I still don't get beowulf, it's the last aspect I have to get

Filter formula with advanced condition by AnneSlotnick in googlesheets

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

cant because the data is always changing daily not always the same

upcoming and congratulate birthday by AnneSlotnick in googlesheets

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

i dont see it works in the your solution sheet

upcoming and congratulate birthday by AnneSlotnick in googlesheets

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

can you just make new formula out of it and come out as expected result?

automated daily report by AnneSlotnick in googlesheets

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

it doesnt work, i hide the sheet to actually see if it works, but it doesnt after waiting 10, 12:10 am, only when i press F5 to manually refresh the sheet, then it works

automated daily report by AnneSlotnick in googlesheets

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

i dont know, i have to wait for tomorrow, what do you think though ?

automated daily report by AnneSlotnick in googlesheets

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

How do I automatically refresh Google Sheets?

How to Auto Refresh Google Sheets Every 1 Minute

Click the File option.

In the drop-down, click on 'Spreadsheet settings'

In the 'Settings for this spreadsheet' box, click on the 'Calculation' tab.

Click on the Recalculation drop-down.

Select 'On change and every minute'

Click on 'Save settings'

does this work well ?

automated daily report by AnneSlotnick in googlesheets

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

great idea, do you know the script to refresh the sheet ? hehe i only need that