jbarrick007
New Member
- Joined
- Jul 9, 2020
- Messages
- 36
- Office Version
- 365
- Platform
- Windows
6.10 | | DEMO/UNDERGROUND | #6.1 | DEMO/UNDERGROUND |
I cant really change A1 to text because of what im doing C3 is looking for a number with the following formula; =IF(AND([@[Workflow '# ]]>1,[@[Workflow '# ]]<10),(TEXTJOIN(CHAR(10),TRUE,"#"&[@[Workflow '# ]]&" "&[@[Milestone Name ]],"")
Any suggestions on how to get C3 to say "#6.10 | DEMO/UNDERGROUND"
Thanks so much for you help.