Currently, I am creating a calculated column called Next Meeting Due
This column is linked to 2 other columns:
Meeting Frequency -> (which can be monthly, 6 monthly and annually)
Last Meeting Date -> (last meeting)
My current formula is:
=IF([Meeting Frequency]="6 Monthly",[Last Meeting Date]+182)
This works perfectly fine, however when adding multiple if statements for Monthly/Annually it doesn't work.
In my head the following formula should work:
=IF([Meeting Frequency]="6 Monthly"
,[Last Meeting Date]+182
)
,[Meeting Frequency]="Monthly"
,[Last Meeting Date]+30
If anyone has a solution or can point out what I have done wrong please let me know.
This also doesn't work:
=IF([Meeting Frequency]="6 Monthly"
,[Last Meeting Date]+182
)
,IF([Meeting Frequency]="Monthly"
,[Last Meeting Date]+30
)