Trending in Formulas and Functions
-
Flagging Duplicates with Multiple Criteria
Hi all, Trying to identify when I get a duplicate that meets both criteria, when the Work Order Number is the same and when the Service Area is the same. I'm using the following formula, =IF(COUNTIFS([Pass Number]:[Pass Number],[Pass Number]@row,Site:Site,Site@row)>1,"Duplicate","Not Duplicate") But its not working…
-
Percentages as progress bars
Hi we are using the below formula to calculate a percentage which is then reflected by a progress bar, when the overall percentage is at 49% the progress bar is showing as "full" instead of reflecting the criteria of the formula underneath =IF([Overall %]@row < 0.25, "Empty", IF(AND([Overall %]@row >= 0.25, [Overall %]@row…
-
Hello! How can I work an OR statement into this formula? I need it to look at 6 different columns.
=IFERROR(INDEX(COLLECT({Provider being reviewed}, {MRN 1}, CONTAINS(@cell, MRN@row)), 1), "")