I need data to be inputted following a certain format. In Microsoft Access I can create an input mask so regarless how data is entered, it will automatically update to the right format.
Example, if data is entered as EAC0145678945, then it will change to EAC-01-456-78945. Monday.com does not support input mask and I haven’t found a formula that works.
This might get you started:
IF(REGEXMATCH({Data}, "^.............$"), REGEXREPLACE({Data}, "(...)(..)(...)(.....)", "$1-$2-$3-$4"), {Data})
Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas: the SECRET Functions
Yes that works, but unfortunately it creates the data in a separate field. I wanted the data to format in the original field. But thanks!
Hi, @JCorrell
Is it possible format a formula colunm to financial amount, like this?
101.666,667 → $ 101.666,67 (here in Brazil we use dot for thousand and comma to cents)
The best way is to change the column format from the group totals line. You can also use the TEXT() function. Just add it to the formula you currently have. For example, if the current formula is “{Cost}/{Rev}” the new formula would be “TEXT({Cost}/{Rev}, “$#,###.##”)”
Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday
