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
-
Retrieving parts of a text fields
Hi there, I have a project identifier column that includes a project code (111-AAA) and project name (client name). Ex: 123-ABC Disney Corp I would like to separate the Project Code and Project Name into 2 Columns, which will result in me having 3 columns Project Identifier, Project Code and Project Name. For the 'Project…
-
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)