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

Elena O
Elena O
edited 12/09/19 in Formulas and Functions


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!

(5) Story Points history - - Google Chrome 2018-08-20 11.56.16.png


  • 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:

    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:

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!