My plan is to add a calculated field that notes when the iteration ID has a value but I can't determine how to do this so that it adds a timestamp of the first time ANY value is present in that field. Here's where I am and this doesn't work:
IF(NOTBLANK{Iteration ID}),IF(ISBLANK({DE:Iteration Assigned Date}),$$NOW,{DE:Iteration Assigned Date}),{DE:Iteration Assigned Date})
Solved! Go to Solution.
Hi Melissa,
From this handy Calculated Data Expressions article, I believe the term "ISBLANK" (vs NOTBLANK) is what you're after, and suggest you try this formula instead:
IF(ISBLANK({Iteration ID})
,{DE:Iteration Assigned Date}
,IF(ISBLANK({DE:Iteration Assigned Date})
,$$NOW
,{DE:Iteration Assigned Date}
)
)
Regards,
Doug
Hi Melissa,
From this handy Calculated Data Expressions article, I believe the term "ISBLANK" (vs NOTBLANK) is what you're after, and suggest you try this formula instead:
IF(ISBLANK({Iteration ID})
,{DE:Iteration Assigned Date}
,IF(ISBLANK({DE:Iteration Assigned Date})
,$$NOW
,{DE:Iteration Assigned Date}
)
)
Regards,
Doug
Thanks Doug! I'm not sure this will work though. I'm looking to calculate the date of the first time that there IS data in the IterationID field. So the first time it goes from blank to not blank.
Views
Replies
Total Likes
Yes, that's what I'm intending too, Melissa; here's the concept:
Worth testing, of course, but I believe it should work.
Regards,
Doug
I see! I'll try it out and let you know. Thank you for the further explanation. Makes so much more sense.
Views
Replies
Total Likes
Doug, thanks for the post. I was having a similar issue and your answer helped me solve the problem. Have a good day.
Views
Replies
Total Likes
Views
Likes
Replies