Recent searches
No recent searches

Leanne Weaver
Joined Dec 20, 2022
·
Last activity Dec 20, 2022
Following
0
Followers
0
Total activity
2
Votes
0
Subscription
1
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Leanne Weaver
Leanne Weaver commented,
CommentBuilding reports
Hi,
When the status is updated, I'm trying to check what the previous value was (what it changed from). I currently have this:
IF ([Changes - Field name] = "status"
AND ([Changes - Previous value]="open" OR [Changes - Previous value]="new")
AND [Comment present] = TRUE
AND [Comment public] = TRUE)
THEN VALUE(Field changes time (hrs))
ENDIF
Are my only options for [Changes - Previous value] "open," "hold," "new," and "pending"? How can I use my custom status fields when checking the previous status?
View comment · Posted Dec 20, 2022 · Leanne Weaver
0
Followers
0
Votes
0
Comments