I've been struggling with the calculated column in SharePoint.
I would like to have a column in which the date is calculated from the values in two other columns. I have one column named "Status", a second column called "Requested Date" and a third column called "Lift Date".
If status is listed as "As Needed" or "Daily" I would like the Lift Date to show today's date, if the status shows "Not Started" then I would like Lift Date to show the Requested Date.
Any assistance would be greatly appreciated.