Help
Pamela_Giles
5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Nov 29, 2018
‎Jan 04, 2024

User Statistics

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

User Activity

TLDR: I'm not able to upgrade to a Business account, and when I go to my workspace, it says it does not belong to my company. I am the sole billable collaborator in that workspace, and I'm listed there as Owner.---I'm a consultant. A year ago, I set ...
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...