Trending in Formulas and Functions
-
Reporting to Dashboard issue
I have my main metric that rolls into a report that is using monies ($) and it worked perfect till this morning. I have checked and confirmed that every cell is in the $ format and yet it is still not showing up anymore on the dashboard as $. There are no blank cells in these columns either. I can not for the life of me…
-
How to Count how many times a cell is in a column
I am struggling with a formula how many times Delta appears in the Client Column. The formula I am using is: =COUNTIF((Client:Client), FIND("Delta", Client:Client, >0))
-
How to reference column name pulled from formula
I'm trying to pull a date from columns based on the number in the helper column. I know I can do this with nested IFs, but is there a way to change which column I'm pulling the value from? My column Start Date should be whatever the column is based on the Index. So for the first column below, since Index is 3, it should…
