Expand my Community achievements bar.

Wondering how Workfront Proof works? Join our AMA on May 8th and ask our Community experts!
RSVP Now

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Text to Date Calculation?

Avatar

Level 4
Level 4
5/26/20 10:06:33 AM

Hi There - Does anyone have a good suggestion on translating text to date w. a calculated field? We currently have an integration that pulls over our development iterations and it laid out as, LTI\Iter\20.19-May08, which = 5/8/20. My only idea is populating my calc w. all Iterations w. an IF statement as shown below, but would prefer not to if there's an easier way?

IF(ADO Iteration = "LTI\Iter\20.19-May08", "5/8/20")

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

Text Mode Reporting

Views

242

Replies

0
Sign in to like this content

Total Likes

Translate
Translate
0 Replies
Related Conversations
How to grant Portfolio access to move document folders Solved

Views

75

Likes

0

Replies

2
Help with changing text color to "red" if task is past due in text mode Solved

Views

192

Likes

0

Replies

9
Creating a column in a report using text mode Solved

Views

122

Likes

0

Replies

2
Adding timesheet to a single user vs additing it thru the layout template

Views

64

Likes

0

Replies

2
Add Resolveables collection to issue report

Views

48

Likes

0

Replies

1