5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Feb 05, 2019
‎Nov 29, 2022

User Statistics

  • 4 Posts
  • 0 Solutions
  • 3 Kudos given
  • 3 Kudos received

User Activity

I have three table : Table one 【member data】 which have {start date} {end date} {single linked to weekly summary} table two【activities】 {date of activities} {multiple linked to weekly summary per person} table three 【weekly summary per person】 {week ...
I tried to use rollup function to got previous data in the same table as below First, I make the lenth of one field to be the same. IF(LEN({TargetField})>10, LEFT({TargetField}, 10), {TargetField}&REPT("_", 10-LEN({TargetField}))) Then in a linked fi...