Hi there! How can I show a specific word in ...

(SABIO Soporte) #1

Hi there!

How can I show a specific word in a doc template for a workflow rule if a particular cell is blank or notblank?

Eg: I had a checklist table, where I need to have a report of the questions that have been asnwer or not. But I don´t need to see the answer per se, I just need to see if the cell on that row is blank or not.

Many thanks!

(Aleksi Alkio) #2

You could write a IF (or IFS) statement like <<IF(ISBLANK([Column]),“Blank”,“NotBlank”)>>

(SABIO Soporte) #3



I just try this:

<<IF(ISBLANK([Column]),“Blank”,“NotBlank”)>><> And for some reason is not showing anything in the workflow doc template when I received the email.

(Aleksi Alkio) #4

Is the whole template blank or just the last column?

(SABIO Soporte) #5


No, the first column of the template show a name and an ID, the other columns of the template must show the values in the IF formula. I am plannig to do this in a 100 columns.

(SABIO Soporte) #6


If you are asking for the template that arrives to the email, yes, it is all blank. check the pic

(SABIO Soporte) #7


Any other thought on this?

(Aleksi Alkio) #8

There are two reasons for this behavior… the list is empty or the FILTER expression is wrongly constructed.

(SABIO Soporte) #9


Ok thanks! Translate

(Aleksi Alkio) #10

Is the Column name correct?

(SABIO Soporte) #11


Yes it is

(Aleksi Alkio) #12

Why do you have that <>? Are you using <Start:> as well?

(SABIO Soporte) #13


Yes, I am using a <>

(Aleksi Alkio) #14

Would you please show the whole “section” so we could understand the possible reason.

(SABIO Soporte) #15


I just share you the doc

(Aleksi Alkio) #16

You had this… <<IF(ISBLANK([Column]),“Blank”,“NotBlank”))>> where you should use <<IF(ISBLANK([Column]),“Blank”,“NotBlank”)>>

(SABIO Soporte) #17


The formula is working perfect if I test it in the expresion builder. But when I triger the workflow, In the email doc is not showing any data. If the column beloging to the table has an editable if filter expresion, that could be the issue why I am not seeing ant data in the email doc?