Formulas - Greater than and less than

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?

Overstock Reserve.yxmd

Developer Tools

Accepted answers

All comments

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

PTP_16 Overstock.xlsx

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

Overstock Reserve.yxmd

PTP_16 Overstock.xlsx

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.

planningDaysUpdated.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703