Formulas - Greater than and less than

[bthursti]

I am trying to create a formula that represents column planning days to zero qty, anything greater than 180 and less than 365 returns the description 180 Days-1 Year in a new column labeled Category (DTZ). I can't seem to figure out how to write it correctly or if there is a different way?

[nagakavyasri]

Include the [Planning Days to Zero Qty] before 365:

if [Planning Days to Zero Qty]<180 or [Planning Days to Zero Qty]>365 then "180 Days-1 Year" else "" endif

[hlee36]

The workflow you attached has the source excel file from your local drive, thus, it is not in the workflow when we download. Can you attach the file "PTP_16 Overstock.xlsx", as well?

[bthursti]

This did not work any or suggestions?

[bthursti]

Here is the overstock report

[hlee36]

@bthursti 

Attached is the workflow.

[Jeff_Neklason]

Good morning @bthursti - The formula above was close. It looks like this formula works: 

if [Planning Days to Zero Qty]>180 and [Planning Days to Zero Qty]<365 then "180 Days-1 Year" else "" endif

The filters are only there to check the results. They are not necessary. 

Jeff

 

[bthursti]

I am trying to filer on specific creation dates and planning days to zero but do not know who to write this. I am looking for the folloiwng:

Create Date < 6 months and days to zero 180 or less = Exclude

Creation Date > 6 months and days to zero 180 or less = Exclude

Creation Date > 6 months and days to zero >180 = Include

[hlee36]

@bthursti 

Based on what you said above, the condition of days to zero < 365 is gone?

I updated the workflow with the formula in the filter tool, I disregarded the condition days to zero < 365 since you no longer mentioned it.

[bthursti]

Does anyone know how to receive the difference in numbers between 2 different dates? Say - 6/30/2023-5/30/2023 and then it would about the difference in a column as 30.