Record IDs are all unique across all tables in a base - but they aren't super friendly to look at. Formula: RecordID()I would recommend using a 3 part formula for an ID that follows the format of [Base]_[Type]_[###]. You can 'code' each additional ba...
Hey @jeremie Convert your Duration field in the lookup to formatting as a number. This should automatically turn it into "Duration in Seconds". Create a new formula field "Duration in Minutes" that turns that duration in seconds into duration in minu...
You can solution this by rolling the field up, showing NaN, then creating a second field that is a IF formula, removing any items that are NaN. IF({Rollup-Field}="NaN", BLANK(), {Rollup-Field})
