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?
Solved! Go to Solution.
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