I’m completely stuck on an issue of automating the extraction of first and last date values of multiple sequences in same row. ‘m using a mail parser and get a lot of data in different formats.
Might that be due to the fact that I have a formula for the date column? And if so, is there any way to work around it? So, when I use it I get no result, no mistake but also no data pull.
Timestamp date appears in format 31-10-2019. “I” column is the column where I have timestamped dates. In B18 I specify the date after which I want to get data. So, some cells in date column are empty and some are with the date.Īfter that I want to use query function to filter by date and i use this: It goes like this: =if(G224 = “Paid”, timestamp(), ” “)īasically, when I change G224 to “Paid” it gives me the current date in that cell. I’d like to filter my data table by dates but my date column comes from a formula using a Timestamp(script). I’m probably having a really light problem but one that I couldn’t figure out. Thank you for your great help and time creating this valuable information!
#HEX WORKSHOP TUTORIAL SHOW ACCESS DATES UPDATE#
Why I purpose change the date today data to MY A2 9:28:53 the data in the query does not update i.e. I am wondering if you have any thoughts or suggestions on this? Here is a link to my sheet – My spreadsheet settings have also been changed to ‘Australia’. Sheets recognises this as a date as a formatted the cells as ‘DATES’. I have followed your instructions, but fear that I maybe limited as I have recorded my dates using DD-MM-YYYY. I have followed your guide to QUERY ( ), even adding in two dynamic selectors (is that what they are called?) that I got from your work on VLOOKUPS ( ). I am therefore trying to get everything working in Sheets first. I have been getting on the GAS and am thinking that QUERY might be a part of my solution.
#HEX WORKSHOP TUTORIAL SHOW ACCESS DATES HOW TO#
My question is how to automate the process of turning that into a monthly post ( ). It occurred to me after nine months that I should really be storing all the links in some sort of database. This year I have been creating a monthly summary of posts and updates associated with all things GSuite.
0 kommentar(er)
