Formula - IF/ISBLANK, Counting #of Days

Platform discussions Special workflows & use cases
1

Hi there,
This was surely asked a 1000x times, and I feel Iā€™m close but cannot identify the error.

I want to count the Days in Onboarding. If confirmed start date is blank, it should count the days from the Release Date to today to check how long someone is in status onboarding. If confirmed start date is not blank, the counting should stop and count the days from released date to confirmed start date and display the actual onboarding time.

=IF(ISBLANK({Confirmed start date}),DATEIF({Release Date},TODAY(),ā€œdā€),DATEIF({Release Date},{Confirmed start date} ,ā€œdā€))

Thanks. :slight_smile:

2

this is what you want:

image
image980Ɨ161 3.24 KB

Here is the formula I used: if({Release Date}=ā€œā€,ā€œā€, if({Confirmed start date}=ā€œā€,round(DAYS(TODAY(),{Release Date}),0),round(DAYS({Confirmed start date},{Release Date}),0)))

The first if statement is just to prevent errors in the event that the release date is blank. If that is certain to never happen you can use this instead: if({Confirmed start date}=ā€œā€,round(DAYS(TODAY(),{Release Date}),0),round(DAYS({Confirmed start date},{Release Date}),0))

I used the same column names you put in your formula so you should be able to just copy and paste mine from here.

3

Thanks, Chris.
The first formula worked, this was very helpful

Cheers,
Tina

1 Like
4

My pleasure! Formulas can be challenging but I love them! They are like puzzles.

Chris Buna
Simplified Workflows

1 Like