The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.
Hi!
I had the following situation when using the following formula to compare dates and determine the current row as the current date.
the first part state if the count I less or equal to 1, that’s the current row,
then if the count is above 1 and ...
Sorry the formula I used was without the braces on today:
IF({Count}<=1, “current”, IF(AND({Count}>1, TODAY() > {Start date}, OR(TODAY() < {Next date}, {Next date}=“”)),“current”))
Solution:
gist.github.com
https://gist.github.com/SamCed/ebf59a1a063fa43e94a25a9c41c14d56
linkfields.txt
//Copy Values to a linked field
//Declare tables
var activeTbl = base.getTable("The table where you need to copy valu...