Trending in Formulas and Functions
-
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: " +…
-
At Risk Flag
Hello All, I'm trying to enable an at risk flag with the following criteria: Within 3 days of date to follow up if the status is either "open" or "deferred" ignoring any rows that have blanks for dates I've been searching the forum, I found one that worked, but flagged every empty row at risk because there were zero…