Microsoft List

Jaime 1 Reputation point
Jun 29, 2022, 3:59 PM

Im trying to figure if its possible to auto populate a date in a column depending on a start date inputted in another column?

also is possible to change column color depending on date range

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,920 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Xuyan Ding - MSFT 7,581 Reputation points
    Jun 30, 2022, 8:32 AM

    Hi @Jaime ,

    Since I'm not quite clear about your autofill condition, I'll give you an example.

    1.I created a column of 'date and time' type called start date and a column of 'calculation' type called next start.
    Set the formula to satisfy the condition. When the start date column is filled, the next start column will be filled automatically.
    216386-image.png 216388-image.png

    2.Modify the format of the column. If column B exceeds column A for more than 14 days, it will be marked in red.
    216453-image.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.


  2. Jaime 1 Reputation point
    Jul 6, 2022, 1:38 PM

    Hi,

    Thanks for the help it worked out perfectly!


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.