If you have two or more separate sheets in Smartsheet, you can use the Cell Linking feature to transfer date values from one sheet (e.g. Sheet 1) to the other (e.g. Sheet 2). When you make changes to date values in Sheet 1, the date values in the linked cells in Sheet 2 will change accordingly. While the Cell Linking feature enables you to change dates across your sheets, it doesn’t let you change the date format. You’ll have to do this manually once you link the cells. 1. Open Sheet 1. 2. Enter date values in a Date type column. 3. Go to Sheet 2. 4. Highlight cells in a Date type column. Note: You can only change the date format for cells in Date type columns. 5. Click the “Cell Linking” button in the horizontal toolbar. 6. Select “Sheet 1” in the left menu. 7. Select the cells whose values you want to link to Sheet 2. 8. Click “Create Link.” 9. Go to Sheet 2. 10. Select the date values in linked cells. 11. In the horizontal toolbar, click on the small arrow button next to the “Date Format” button. 12. Select the date format you want. Unfortunately, this is the only way you can change the date format of date values linked to cells in another sheet.