6 - Interface Innovator
6 - Interface Innovator
since ‎Oct 12, 2022
‎Dec 01, 2023

User Statistics

  • 32 Posts
  • 0 Solutions
  • 13 Kudos given
  • 7 Kudos received

User Activity

I have a table of Properties, and a table of Transactions. I would like to do an interface, whereby one can first select the property, and then enter the date range.Based on that, i wanted to show the Transactions which match the PropertyId, and are ...
I'm not sure if this is possible, but I'm going to try my luck. I have a table with a lot of columns, and lots of records.  Sometimes, I need to find a particular set of records.  Considering I have say 100 columns,  I then need to locate the column....
This is very useful for multiple nested conditions, and is basically a string of multiple IF-conditions, with the 'ELSE" condition being another IF.  The google sheets documentation for the IFS function clearly explains this.  It would be very helpfu...
I would like to parse a date string of "2023-02-10", with no time information, into a specific timezone (Europe/Malta). We use daylight savings, so right now, 2023-02-10 00:00 Malta time would be 2023-02-09 22:00 GMT.  For this reason, I cannot speci...
I have a description field, and would like to generate it based on values.  I could not find any way to format numbers, like there is DATE_FORMAT for dates.  The TEXT function in Google Sheets allows you to format exactly like you want it. In my case...