MichaelTCA
MichaelTCA
Reactions
-
Re: Formula with symbols when a cell is NOT blank
@DianaMS Try adding this syntax to your function. =IF(Date@row = "", "Gray")1 · -
Re: How to display one cell of a report within a dashboard.
Hello @Remy V You can select one cell to display by using Metrics.1 · -
Re: sum if based on values
Hello @BrigitteM Based on your example, you could use a SUM() and COUNTIF() function. =SUM((COUNTIF(range,"often")*3),(COUNTIF(range,"sometimes")*2),COUNTIF(range,"rarely&quo…2 · -
Re: I keep on getting an error that says that my formula contains a maximum number of different cross r
Hello @Nonkululeko Changing the function will not help remove that error. Your function is also adding ranges. I do not believe you can add ranges together without another function to analyze them li…1 · -
Re: Potential IF/AND with multiple criteria (each listed multiple times)
@Sherry Fox Haha darn it, you got me there! Don't tell the group of champs. 😉1 ·
