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’ll do my best to describe this.
Description
I have a base with two tables. Table 1 is an import of course records in a csv file. Table two is linked to a sanitized view of this data. Each course has a unique identifying number. Some of these course...
I am trying to convert TODAY() to the WEEKDAY() and then to the single letter for that day of the week. I need to match that to a data feed that provides the day of the week as a letter. Here is my formula:
SWITCH(WEEKDAY(SET_TIMEZONE(TODAY(),'Americ...
I am getting an export that expresses a start and stop time as text in 24 hour format. I am trying to make this into AM/PM. Thoughts?
Input:
730
1130
1330
1700
Desired Output:
7:30 AM
11:30 AM
1:30 PM
5:00 PM
Hey there.
So, I have a base with a table of inventory of devices that includes their IP address. On that table, I already made a button column that where you click on it and it takes you to that device using the protocol best suited for it (VNC, HTT...
I am attempting to have an automation that every Monday morning will look in a table for specific records and then broadcast that into Slack.
I got the trigger and record searches to work, but when I attempt to place them in the message, all I get ar...
Good clarifying question.
It’s #2. All courses have the field. It is blank if they are not cross listed and have a unique pairing code (that can span as many as for courses).
I stumbled into a solution, but I think I am taking too many steps or it is...
No. Right. I knew lookups always return as arrays. What tripped me up is the lookup formatting was set to integer. I can even do something like {Lookup Field}+50 and it will add 50 to the value.
So, at the very least, it is an inconsistency where som...
Ah ha!
Had to use the ole &'' trick on it cause even though the lookup formatting is making it an integer the formula is still treating it as an array cause it is a lookup field type. That might be a bug…
I forgot to mention (sorry) the time data is coming from a lookup. ARRAYUNIQUE and ARRAYFLATTEN don’t seem to be doing the trick, so it’s returning an #ERROR. The lookup is already formatted as an Integer and it works for doing basic math, so super o...
Interesting.
I always thought NOW() was when you put the command into the formula and that it didn’t update dynamicly. I’ll try it.
EDIT: I’ll probably have to wait for the GMT rollover at 4PM PDT to see if it works. Cause it’s hard to tell since Air...
