Jun 21, 2018 01:35 PM
Hello!
I’m a newbie to conditional formulas, and I’m looking for a way to check whether a timestamp for a record is between two different dates.
Fields: Timestamp, Amount Paid, Show/Hide Amount Formula, Totals Rollup Field (in another table)
I want the formula to check whether the Timestamp is between two dates (usually the 1st and 15th of the month). If the timestamp IS between those dates, it would show the amount paid (and if not, it wouldn’t show). I’d then like to use that data in a “Totals” Rollup Field for that date range in another Table.
Jun 22, 2018 12:28 PM
Yes! Exactly :slightly_smiling_face: How did you do that?
Jun 22, 2018 12:33 PM
Jun 25, 2018 10:48 AM
Awesome! Thanks so much :slightly_smiling_face: