If formula & subtracting dates

Platform discussions Special workflows & use cases
, ,
1

i am getting ‘true’ where i think i should be getting a #value.

i am trying to calculate age for multiple status.

if status is ‘delivered’ then calculate days between ‘sold’ date and ‘grounding’ date.

if not status is not ‘delivered’ but is ‘grounded’ then calculate days between today and ‘grounding’ date.

if any other status other than ‘delivered’ or ‘grounded’ the age should be blank

my current formula: IF({Status}=“Delivered”,DAYS({SOLD DATE},{GROUNDED DATE},IF({Status}=“Grounded”,DAYS({GROUNDED DATE},TODAY(),“”))))

monday pic
monday pic402×767 28.2 KB

2

i appreciate any help getting this formula correct!

3

@JCorrell i have seen your great help for others…have any ideas on my formula? it seems as if the different groups is the issue. i can do a ‘one’ if statement and that particular status/group works perfectly (showing blank value for the ‘“”’)…but all other status/groups only show ‘true’

4

@StephenP

Looks to be just a couple of misplaced ")"s.

Try this:

IF({Status}="Delivered",
  DAYS({SOLD DATE},{GROUNDED DATE}),
  IF({Status}="Grounded",
    DAYS({GROUNDED DATE},TODAY())
    ,""
  )  
)

Jim - The Monday Man
:magic_wand: Update Magic #1 – New update enhancement toolbox
:magic_wand: Column Magic :sparkles:– The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday

1 Like
5

thank you very much. happy new year

1 Like