Jump to content

Worksheet formula in Title Block Linked Text field


Recommended Posts

Hello,

 

I'm trying to achieve the below in a title block border - the first 2 chars of the Suitability Status.

 

I believe I need to use the #WS_ worksheet formula to let me access the LEFT function, but no combination I try seems to return a value. Can someone please confirm the correct syntax.

 

Thanks

image.png.82aa224ead9da92a34470403af32ac76.png

Link to comment
1 hour ago, Pat Stanford said:

You need the other # after the last parentheses

 

That was my thought but when I tried it earlier it didn't work. I assumed worksheet formulas weren't allowed in TBBs but perhaps I got something wrong...

Link to comment

Reading to quickly. Sorry about that.

 

Yes, Title Blocks do not appear to be able to use Worksheet formatting.

 

I think you may be able to accomplish this by adding an extra field to the Sheet Data and then using the Data Manager to store the short value. But I have not made it work yet and need to get back to real work.

Link to comment
  • 2 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...