Richard Rymill Photo

2

Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that list.

Our Developers, using the Smartsheet API have created just that solution, in fact we have

1

Any plans in the future for letting us update the dashboard background color to any color we'd like? I'd love to be able to use black for dashboard backgrounds, as well as the backgrounds of the widgets, so that when on TV sets around the office, graphs are floating in black instead of a white

1

With the Jira Connector, is it possible to pull all the sprints into Smartsheet based on the sprint as the unique item/key, not the individual issues? I'd like to better see all our sprints across all our teams and report based on the most recently closed sprints in a given project.

Since I can't

2

Hello friends-

I am creating a spreadsheet to help track project financials for a specific grant that the non-profit which I work for received. 

Specifically in the Summary Table, I have a sumifs formula which grabs specific line items based on the date and which installment of the grant they are

1

Does anyone have experience working with DocuSign "Radio Groups" and merging those fields to data inside Smartsheet?

I have been utilizing the Smartsheet/DocuSign integration for several months with great results, but there are a few areas I am running into issues - this being one.

I have

4

Hi,

I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value.

=SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value})

The sheet references are to single columns titled 'Completion Date'

1

Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column.  There will be several matches per ID, e.g. Matt worked item 1..  2...  3.. and 7.  I want to return the information relative to that ID for those entries.