topic Re: Conditional If then to return values for ranges in Discussions

Conditional If then to return values for ranges

ByrdQuestions — Sat, 10 Jun 2023 23:44:39 GMT

I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number 19,20,21,22,23,24,25,26,27 etc.)

Re: Conditional If then to return values for ranges

txnelson — Wed, 23 Feb 2022 20:12:31 GMT

I am not understanding exactly what you are looking for. Could you please provide a sample data table with the values you expect to see?

Re: Conditional If then to return values for ranges

Georg — Wed, 23 Feb 2022 23:11:49 GMT

Perhaps this is a starting point, it checks, if the number of runs per campaign is greater or equal 9 days. However, it does not check whether days are consecutive, that's possible, but more complex. If that's needed, it would be really better if you could provide examples.

Key is the function "Col Number", see Scripting Index for details.