Control Center and date formatting

Manu Ed

Hi there, i'm facing a simple issue. When using CC with data profiles, in my intake sheet, i'va got a date field in Eureopean format ( DD/MM/YY). In the destination shhet created with CC, the date format is MM/DD/YY in description field in the summary part of the created sheet.

Any idae to change the format directly and keep the inital one ( DD/MM/YY) ?

Many thanks.

CCissue.png

Genevieve P.

Hi @Manu Ed

Who owns the created sheet? Is it possible that their personal settings are set to US date format?

It looks like you have this field mapped to a text/number column (the Description column) which could be changing the date format. I would recommend mapping the date into a Date column from your Customize Profile Data:

Then you can use a formula to bring it over into the Description column with the correct format:

Cheers,

Genevieve

Manu Ed

Hi Genevieve, thanks a lot and sorry for the delay. I try it, but, as my date column is used in the project parameter, i've this message each time i create a formula : #INVALID COLUMN VALUE.

CCissue2.png

My goal is to generate automatically the first task date as the same of the Prfile data from the intake sheet.

Have any idea? Thanks again

Genevieve P.

Hi @Manu Ed

What formula are you using?

Since you're bringing a Date into a Text cell, you'll need to add quotes at the end of it, like so: + ""

Manu Ed

Hi Genevieve, thanks it works now ! Last step, i'm trying to get this date in my first task : please see atta

CCissue3.png

chment, what kind of formula i need to write? Thanks again!!

Genevieve P.

Hi @Manu Ed

It would be easier to grab the date from the same column, up above!

I can't see your column name, but you would want to type in the Column Reference and Row Reference for the formula to know what cell to populate down below. You'll also want to lock the formula to that one cell by adding a $ sign before the Row Reference, like so:

=[Date Column]$12

This would be the formula if I wanted to bring in Row 12's Date. Does that make sense?

See: Create a Cell or Column Reference in a Formula

Manu Ed

Thanks a lot Genevieve, yes, i tried this solution, but each time, i've got an issue. I think it is because my column is a date column

CCissue4.png

I'm going to check if it is possible to add a formula on a date column? many thanks again.

Manu Ed

I found this on a discussion :

Start and End Date

Duration

% Complete

Predecessors

NOTE: Formulas aren't allowed in the columns listed above when dependencies are enabled.

Genevieve P.

Hi @Manu Ed

Yes, you are correct, if a Date column is being used with Dependencies in the sheet, then you won't be able to add a formula to that cell.

It sounds like there may be a number of small details you need set up. I would recommend checking to see if your account has access to Pro Desk sessions. You can book a session specifically under the Control Center category to receive coaching and guidance over a Zoom session, here: https://www.smartsheet.com/pro-desk. The System Admin for your organization should know your access code if your plan is eligible.

Cheers,

Genevieve