Is there a way to have a formula output into a text string?

Jay M

QUESTION:
How to create a Text string output from a formula that can be copied and pasted into other applications.

BACKGROUND:
I have a large project that requires many Discovery sessions and have a sheet with a form that collects meeting infromation, agenda, and atteendees required so that the PM's can schedule them across the organzation, System implementer and vendor.

LOGIC:
Based on data, I am combining the information with a fromula for the Meeting Subject line:
<PROJECT CODE> + <WORKSTREAM> + <SUB CATAGORY> + <COUNTRY> + Subject that I manually enter + <(DATE)> . Use IFERROR so if one of the cells is empty it will not toss an error.

Desired output is:
WDP2 - PROJ- Weekly Workstream Session + US/CA/UK/IE - Discovery Session (01JAN25)

FORMULA:
=IFERROR("WDP2 - " + Catagory@row + IF(ISBLANK(Catagory@row), "", " - ") + [Sub Catagory]@row + IF(ISBLANK([Sub Catagory]@row), "", " - ") + [Country Code(s)]@row + IF(ISBLANK([Country Code(s)]@row), "", " - ") + "Subject - (DATE)" , "")

RESULT:

This is what is desired, but there is no way to "Copy/Paste" into the Iinvitation email to be able to change the Subject - (DATE) since the cell is a Formula and not a String Text

Anyone have a solution?

prime_nathaniel

Jay M

I am not sure your use case is clear to me…. so you have a cell with a formula that outputs

WDP2 - PROJ- Weekly Workstream Session + US/CA/UK/IE - Discovery Session (DATE)

and you want it do output

WDP2 - PROJ- Weekly Workstream Session + US/CA/UK/IE - Discovery Session (01JAN25)

If you could rewrite this that would be most appreciated - "This is what is desired, but there is no way to "Copy/Paste" into the Iinvitation email to be able to change the Subject - (DATE) since the cell is a Formula and not a String Text"

If all you want is a date in parenthesis you can do that with "(" + [Date] + ")".

If you want that particular formatting of 01JAN25 you can break date into its components via year([date]), month([date]), day[date] or you can use left() or right() to pull pieces of ISO formatted string.