This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 93%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
I'm trying to calculate a due date field based on two other fields in a SharePoint Online list: [Created] and [Priority]. [Created] is auto-populated when the user creates the new list item. Easy enough. The user selects a [Priority] (Critical, High, Medium, Low). My formula always results in an error due to the pre-populated date field. Surely there's a way around this that I'm just ignorant of. It works fine in Excel, but SP pukes when I try it. TIA!
=IF([Priority]="Critical",[Created]+1,IF([Priority]="High",[Created]+3,IF([Priority]="Medium",[Created]+7,[Created]+14)))
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 1%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Hi @James Snider ,
Per my test, you could add a new calculated column with your formula. Remember to select "Date and Time" in "The data type returned from this formula is".
Here is my test result.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @James Snider ,
I'm checking how the things are going on about this issue. Is there any progress on this issue?
Thanks for your reply! However, I'm still hitting the same error wall. I've included a screenshot of my calculated field settings and the error I get. The Create Date is auto populated when the list item is made. I want to calculate the Due Date based on Create Date + Priority.
Neither of these formulas worked: =IF([Priority]="Critical",[Created]+1,IF([Priority]="High",[Created]+3,IF([Priority]="Medium",[Created]+7,[Created]+14)))
=IF(Priority="Critical",Created+1,IF(Priority="High",Created+3,IF(Priority="Medium",Created+7,Created+14)))
Hi @James Snider ,
Like my answer said, you could add a "Due Date" ****calculated** column** with your formula not a Date and time column. You could use something like WEEKDAY function in Calculated Value, but you could not use other fields. In my answer the "create date" column works just like you said "based on Create Date + Priority". Sorry for the wrong name, I should rename it "Due Date".
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 21%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
I experience the same problem. I believe the difference is between the column type, Calculated, in @CaseyYang-MSFT 's reply, and Date and Time, in your example. Calculated type allows for references to other columns, however even formatted as a date, is not available for Calendar view. Date and Time allows functions and formulas but not other columns.