hey I am wanting to list the dates say from 20th march and so on down the page in a single column


  • Malaina Hudson
    Malaina Hudson ✭✭✭✭✭
    edited 03/11/21

    Hi, @aaron tuheke.

    Here's one way to do it.

    In your DAY of WEEK column, use this formula.

    =IF(WEEKDAY([Appt Date]@row) = 1, "Sunday", IF(WEEKDAY([Appt Date]@row) = 2, "Monday", IF(WEEKDAY([Appt Date]@row) = 3, "Tuesday", IF(WEEKDAY([Appt Date]@row) = 4, "Wednesday", IF(WEEKDAY([Appt Date]@row) = 5, "Thursday", IF(WEEKDAY([Appt Date]@row) = 6, "Friday", IF(WEEKDAY([Appt Date]@row) = 7, "Saturday")))))))

    After you've input the formula, right click on one occurrence of the working formula and choose "Convert to Column Formula." This will autoapply the formula to all rows in the DAY of WEEK column and will show a day of week where a date is added in the referenced date field.

    Then, in your date field, you can select 3 or more consecutive dates, grab the lower right corner of the box, and drag down to autofill to the end of your range.

    Should you want or need to modify the formula in the DAY of WEEK, you would need to right click a cell that holds the formula and choose either Edit Column Formula or Convert to Cell Value to edit conventionally.

    Give it a try and let me know if it helps.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!