This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am trying to create a slice where it needs to display the rows with
todays date as match (no matter what the time is)I have tried with
https://prnt.sc/H3svPoE97nbGDATE([Next Action Date]) >= TODAY()The table
definition is here: https://prnt.sc/24ic...
I have a many rows each with repeating and non repeating values for the
field LOCATION,I offer it to search, but the search list itself needs to
be sorted, My formula placed here didnt work. Any insights would be
great.Also tried with
I have created a virtual column to bring data from PROJECT DETAILS tab
sheet, I could get it successfully using the formula SELECT(PROJECT
DETAILS[Google Location Map], ([Project Code] = [_THISROW].[Project
Code]))But I want to make user look like a ...
I am using 2 tables PROJECT DETAILS and CONFIGURATION, They are joined
with a key called Project CodeThe PROJECT DETAILS contains
apartment/building details and CONFIGURATION table contains details of
each room in the floor.I want to append the selec...
There are records below. But this doesn't work. I have already posted
this in my questionToday is 28th in my
Geohttps://prnt.sc/6LVUNJKpbn9OThere must be a way to do this, I am not
sure. https://prnt.sc/8pUj1ykiKxYg@Steve
Thanks for that, but the actual problem was to sort a filtered list
rather getting the right syntax of SORT. It makes sense to sort the LIST
instead of ENUM.I did as you suggested, but still no luck
The spreadsheet formula is for Generated from the spreadsheet. Gets
applied during sync. This has nothing to do with sort I believe.Your
formula gives error
