Help
Melissa_Frank1
6 - Interface Innovator
6 - Interface Innovator
since ‎Jan 30, 2019
‎Jul 22, 2024

User Statistics

  • 17 Posts
  • 0 Solutions
  • 6 Kudos given
  • 18 Kudos received

User Activity

I have various contracts and various contractor invoices that I need to review, and I want two formula fields to confirm whether the billing periods covered by each invoice - and the invoiced amount - are "valid". My table is pulling in the contract ...
I am trying to create a table that calculates equipment depreciation by straight line, sum of years, and double-declining, because we have a number of different equipment types that depreciate in very different ways, but want to monitor all of them i...
I have one table of people, and another with records of their visits. In the people table, I am trying to add a field that will tell me the date of the earliest visit… after 9/30/2016. I tried adding a formula field in the visits table to return the ...
I am trying to add a formula field that replaces all spaces in a long text field with “+”, and all paragraph breaks with “\n”. How do I designate a paragraph break in a formula? SUBSTITUTE(SUBSTITUTE({Event Details},’ ‘,’+’),< p >,’\n’) won’t even s...