Formula to copy a value to cell which is defined by day of month

Elena O

Hello!

My goal is to create a sheet where I want to store the values which are updated every day during sync with Jira. And I want to copy a value to a cell that is corresponds to current day of week. 

The result should be something like on the screenshot.  

So I need some kind of formula: value from Jira copied every day to another column which is +1 to previous, for e.g. - in Monday the value is saved in the column #1, in Tuesday it is saved to column #2 and so on. And as a result I will get a sheet with all values that was synced during the week. 

Can you please help me understand is this possible in any way? 

Thank you!

Shaine Greenwood

Hi Elena,

The Jira Connector may be able to sync values to a sheet for you. More information on this can be found here: https://www.smartsheet.com/jira

After syncing values, as long as date values are being synced to date columns, you could create a COUNTIF function that counts the number of cells that have a specific day of the week with WEEKDAY. An example if this is as follows:

=COUNTIF({Jira Sheet Dates}, WEEKDAY(@cell) = 1)

Details on the functions used in my example are available here:

• COUNTIF
• WEEKDAY
• @cell