Share via

Microsoft Lists Calculated Columns - Dates Formula

Anonymous
2023-04-12T14:34:46+00:00

I'm trying to add a calculated column in Lists. The formula I'm entering is not being accepted and the column is showing up without an active formula.

Here are the steps I've followed:

Added Column - see all column types - next - calculated column with date setting

Formula =DATE(YEAR([COL 1]+[COL 2]),MONTH([COL 1]),DAY([COL 1])

I can't delete the column nor check or edit the formula. The List settings are not showing as described in steps I find online. I really need help with this as I'm going around in circles and having to delete the entire list to just set up another List that doesn't work.

Thanks

Microsoft Teams | Microsoft Teams for business | Files | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-04-12T15:18:32+00:00

    Hello Tatiana,

    I'm Jane, happy to help you today.

    I'm very sorry about your problems. This seems to be permission issue, You'll need to reach-out to your IT Administrator to allow your permission to be able edit the formula.

    Please let me know if you need help with anything else.

    Sincerely,
    Jane.

    Give back to the community. Help the next person who has this issue by indicating if this reply helped you. Click Yes or No below.

    0 comments
  2. Anonymous
    2023-04-12T15:26:07+00:00

    Hi Jane,

    I am the administrator so some guidance here would be welcome.

    Thanks

    0 comments
  3. Anonymous
    2023-04-12T22:08:56+00:00

    Good, due to the technicality of this issue and you're the administrator, I'll like you to relay your concern to the Q&A forum.
    Here is an end user to user support, there are more Administrator and teams developmental team in the Q&A forum and they have more professionalism to attend to enterprise question like yours. https://docs.microsoft.com/en-us/answers/produc...

    0 comments
  4. Anonymous
    2023-04-13T05:31:14+00:00

    Hello,

    Have u tried on MS List for iOS app? If not working then u may file a report via the feedback option within that app someone from MS will reach out u via email.

    0 comments