Hello, I have 2 problems that I can’t figure out and would appreciate any help
#1: I have a column [Checked out by] and it has app formula =ifs([Status]=“In work”, useremail() ) so it stores who has checked out the item.
Then there’s another column [Installed by] with similar formula =ifs([Status]=“Installed”, useremail())
When status changes to Installed, it deletes the useremail from [Checked out by]. Why it does that?
#2: There’s changeTimestamp column for for Status “In work”, and another column for “Installed”, they work fine.
Changing the status to “In work” also changes status in parent table to “Started” with changeTimestamp, no problem yet. “Installed” changes from “Started” to “Finished”, but now the changeTimestamp is -3 hours from correct time!!?
LinkedIn
Twitter
