Trending in Formulas and Functions
-
Importing Excel Files
Hi All! Does anyone know why sometimes it shows " ' " in a cell when an excel file is imported? I´m having a hard time when it happens because VLOOKUP formula cannot find the information ... Thank you & Regards, Camila
-
How can I tick a box based on two criteria?
I'd like to tick a checkbox based on another checkbox being ticked and for a specific task name. I have the following formulas that work individually. How can I combine them? =IF([Checkbox]@row = 1, 1,0) =IF([Task name]@row = "XYZ", 1,0)
-
how can I display multiple spaces? " "+" "+" ", Char(32) + Char(320 etc...?
I am trying to create concatenated text with multiple continuous "spaces" so I can map that in PDF in one go, like below. ID: XXXXXXXX1 Name: First Last ...... ID: XXXXXXXX2 Name: First Last ...... With the formula below, " " will endup with single space as well as Char(32)+Char(32). "ID: "+[ID]@row + " "+"Name: " +…