Create a calculated column using beast mode
I would like to calculate the following using beast mode, having the results in a new column.
column name: Start Date "9/1/2019"
column name: Days Ago "2"
If column "days ago" has a number in it, then take the date in the "start date" column and subtract it from the number in column "days ago"; resulting in the new "activity date".
If column "days ago" is null (has no data), the result is: "start date"
New column is: Activity Date
Any assistance is greatly appreciated.