Entring hard code data through automation

[sgaryali]

Hi

I want add manual data based on the condition :-

1) Start Date I have to take from D column(Hospital stay from) and end date E column (Hospital Stay to) 
    i.e for dates -

4/12/2022

4/13/2022

4/14/2022

4/15/2022

Interval type (I column)  will be - "Hospital"

2) For rest of the date

 i.e for dates -

4/16/2022

4/17/2022

4/18/2022

4/19/2022

4/20/2022

4/21/2022

4/22/2022

4/23/2022

4/24/2022

interval type (I column) will be - "Non Hospital"

How can we do this?

[JagdeeshN · Accepted solution]

@sgaryali ,

Have you tired this formula:-

if [Dates]> [End_Date] then 'Non Hospital'
else 'Hospital'
endif

Please find attached a sample workflow to showcase the same.

Best,
Jagdeesh