DATE PLUS TO CHANNEL WISE NUMBER OF DAYS

[Sirfyaad]

I want [date] to be plus [NUMBER OF DAYS] if [channel] of the reference sheet and [channel] of the main sheet are equal.

REF SHEET:- DAY COUNT

CHANNEL	NUMBER OF DAYS
Adidas	42
New Balance	4
Converse	12
Vans	7
Reebok	2
Puma	7
Saucony	3

Like this.

like this

[rmsmeltz]

@Sirfyaad try this: `[Date] + LOOKUP([Channel], Table Reference, Channel, Number of Days)`

[Sirfyaad]

[DATE] + LOOKUP([Channel], Day Count,Channel, NUMBER OF DAYS)

(The value of column 'DATE' + One randomly chosen value from this list (
........The list of values of column 'NUMBER OF DAYS'
........from rows of table 'Day Count'
........where this condition is true: ((The value of column 'CHANNEL') is equal to (The value of column 'CHANNEL'))))
Test
open_in_new

NOT working showing only date. @rmsmeltz @Joseph_Seddik 

[Sirfyaad]

The function that I have done, it is giving only current date. @Joseph_Seddik @rmsmeltz 

[Joseph_Seddik]

Did you try to implement the solution I gave you? Is there something you don’t understand in my reply so that I can try to explain better?

[Sirfyaad]

All the methods you mentioned. I tried to swim but did not succeed. I want you to tell why this expression is not working. Here, the expression is giving only the current date only. 

---

@Sirfyaad wrote:

[DATE] + LOOKUP([Channel], Day Count,Channel, NUMBER OF DAYS) (The value of column 'DATE' + One randomly chosen value from this list ( ........The list of values of column 'NUMBER OF DAYS' ........from rows of table 'Day Count' ........where this condition is true: ((The value of column 'CHANNEL') is equal to (The value of column 'CHANNEL')))) Test open_in_new

---

[Joseph_Seddik]

Your reference sheet app table should have a key column and your CHANNEL column in this table should be marked as Label.

In the main sheet, the column CHANNEL should be a Ref  pointing to the reference sheet app table. This column would contain the key column values in reference sheet, but users will see the values of the Label column. 

With this, you can use the following app formula in your EXPIRED DATE column: [DATE] + [CHANNEL].[NUMBER OF DAYS]

[Sirfyaad]

I want sum on this conditoin.

CHANNEL	NUMBER OF DAYS
Adidas	42
New Balance	4
Converse	12
Vans	7
Reebok	2
Puma	7
Saucony	3

[Joseph_Seddik]

I already gave you the answer in detail. Is there something you don't understand?

[Sirfyaad]

You are so kind to help. But till now its solution has not been found. Please help me a little more to solve this. I want [number of days] in [date] to be plus when [channel] is equal [channel].

See Below Expression:-

[DATE] + LOOKUP([Channel], Day Count,Channel, NUMBER OF DAYS)

(The value of column 'DATE' + One randomly chosen value from this list (

........The list of values of column 'NUMBER OF DAYS'

........from rows of table 'Day Count'

........where this condition is true: ((The value of column 'CHANNEL') is equal to (The value of column 'CHANNEL'))))

Test

[Joseph_Seddik]

I'm glad to help you out. Please try to implement the following solution one step at a time and tell me if you have difficulties:

1. Your reference sheet app table should have a key column and your CHANNEL column in this table should be marked as Label.
2. In the main sheet, the column CHANNEL should be a Ref  pointing to the reference sheet app table. This column would contain the key column values in reference sheet, but users will see the values of the Labelcolumn. 
3. With this, you can use the following app formula in your EXPIRED DATE column: [DATE] + [CHANNEL].[NUMBER OF DAYS]

[Sirfyaad]

[DATE] + LOOKUP([Channel], Day Count, Channel, NUMBER OF DAYS)

 tell me about this function, he function that I have done, it is giving only current date. why

@Joseph_Seddik @rmsmeltz 

[Joseph_Seddik]

I don't know. I've never used LOOKUP() and you don't need it. 

[Sirfyaad]

[DATE] + [CHANNEL].[NUMBER OF DAYS]
Column CHANNEL in expression '[CHANNEL].[NUMBER OF DAYS]' does not contain a reference

[Joseph_Seddik]

Do the three steps in order, not just the last one. 

[Sirfyaad]

---

@Sirfyaad wrote:

CHANNELNUMBER OF DAYSAdidas42New Balance4Converse12Vans7Reebok2Puma7Saucony3

---

I want to sum in on its wase.

[Joseph_Seddik]

What?