am facing issue here as am trying to use type in activity with if condition for Excel as you know it contains ββ
and after typing the if condition it gives error
kindly advice
First off: the Excel formula should put between quotes (not visible in the screenshot).
Have you tried to replace the quotes in the formula with 4 single quotes (like: ββββ)?
Otherwise put the formula in a variable with placemarkers for the quotes and then use the Replace Text activity to put in the quotes.
Like @Carel mentioned, the TypeInto requires that you type in a string, so you just need quotations around it. Doing so will also require that the embedded quotes be 4 quotes.
For example,
β=If(TODAY()-A5<=3,ββββNOT DUEββββ,βββ"Out of SLA β¦ "
I will also suggest using the Write Cell activity for placing formulas into Excel so you donβt need to rely on keystrokes to get to each cell.
Thanks.