Help
Pamela_Giles
5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Nov 29, 2018
‎Aug 19, 2023

User Statistics

  • 10 Posts
  • 1 Solutions
  • 6 Kudos given
  • 4 Kudos received

User Activity

I'm trying to format Canadian postal codes. Often the person enters them as k0e1b0. I need them to look like K0E 1B0. UPPER({PostCode}) will make them upper caseREPLACE({PostCode},4,0," ") will put the space in the middleHow can I do both of these st...
This seems like ridiculously easy formula to write, but I’m stymied. IF({Paid} ≥ {120%}, ({Paid} - FMV),0) If the person Paid more than 120% (120% is a column calculating 120% of the Fair Market Value), then the value of their tax receipt is the amou...