I need identical values throughout a column in order to set-up calculated fields properly. I want the first row to copy itself throughout the entire column whenever the user inserts a date into the first column.

thanks.

• Edited by SharepointHelpNeeded Monday, May 18, 2015 3:10 PM

Hi,

You can create a date field and then give it a default value that you want.

Thanks,

Hi,

According to your description, my understanding is that you want to copy the value of the first column to other items.

Designer workflow is a good option for you. You could judge whether the column is the first one. Then copy the value of the first column to other items.

More detail steps:

Best Regards,

Dean Wang

Dean,

I want have it so when the user types in a value at the top of the column, the value will copy into each row within the column. for example.

when a user types in 12/30/14 into row 1, it copies down the column

EX.)

DATE                                                                               $ AMOUNT

12/30/14 (USER TYPES THIS)                                                  44

12/30/14 (COPIES AUTOMATICALLY)                                      55

12/30/14 (COPIES AUTOMATICALLY)                                       54

12/30/14 (COPIES AUTOMATICALLY)                                       43

If everything, really everything, in the list uses the same date then you could just hard code that into your calculation.

You can't use default values as they are only populated when an item is created, updates won't get it.

Workflows could work but it's a pain to write them and execute them on large datasets.

The Datasheet view might be worth a look if you're under 200 items or so.

For larger data sets you're best off with PowerShell.

The list is about 50 items long. The problem is that I need THE USER to be able to enter different dates at the top as they change. I need the dates to copy to the bottom as other columns will be using these same dates for calculations. In excel, we could just have the date in one cell and reference it. I am a beginner in sharepoint, though i don't think this is possible. What is my best option here?

Hi,

Event receiver is a good option for you. You could update list items using SharePoint Object Model in event receiver.

Here is a step by step sample on creating a simple Item added event receiver for Custom List in SharePoint 2010:

https://msdn.microsoft.com/en-us/library/ff398052.aspx

More information about Event Receiver for your reference:

https://msdn.microsoft.com/en-us/library/gg749858(v=office.14).aspx

Add, Update and Delete List Items Programmatically in SharePoint using SharePoint Object Model:

http://www.mindfiresolutions.com/Add-Update-and-Delete-List-Items-Programmatically-in-Sharepoint-372.php

More information about SharePoint Object Model for your reference:

https://msdn.microsoft.com/en-us/library/ms473633.ASPX

Best Regards,

Dean Wang