Newbee to automations here and would like to hear if I’m doing this right because it feels wrong :slightly_smiling_face:
I added a couple of automations which change a status field based on conditions. So as “Action” I select “Update record”, selec...
@Markus_Wernig @Joe_Svingala @Miles_Mattison @Christopher_Cantrall @Curtis_Gabhart_CCIM you can use the formula below (instead of creating many columns to achieve this):
REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPL...
@Jordan_Dayton you can also use the formula mentioned here: We still need a simple TITLE CASE (PROPER) function alongside UPPER and LOWER - #6 by gxjansen
@Adam_Parker Still a workaround, but instead of creating a lot of columns to achieve this, you can also use the formula mentioned here: We still need a simple TITLE CASE (PROPER) function alongside UPPER and LOWER - #6 by gxjansen
@airtableManuel You can do this with this formula:
REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REG...
Some clarification questions:
Are all these start/end dates in the past and (based on that) you want to make a (MRR-like) prediction for the future, OR are these dates the actual contract start/end dates (past and/or future) and you just want to know...
