TDobson✭✭

This item does not appear to have been dealt with that I can see. Was a solution created?

看来Shuttl数据e will not give me the functionality. I will look into the ODBC Connector solution. Thank you for your assistance.

Thank you for your response. Would data shuttle allow me to make a connection to the excel sheet so that when values are entered on that sheet those values would populate the columns in the smartsheet.

Good day, I am using this formula to look for distinct values in a column and counting them. =COUNT(DISTINCT(COLLECT({Mobile Regression Jira's Created}, {Mobile Regression Jira's Created}, <>""))) I have cells with in the column that have multiple numbers. Does the formula look at each number separately or is it counting…

I am ok with Results Are Empty as long as when the results show up that they auto populate.

Thank you I tried that and it worked perfectly.

Thank you for your quick response. I will try that.

Here is a snipit of the 2 columns. The Incentive Date column is a date column.

Thank you for your responses. It will be a general link. I have already temporarily created a workflow, but would like away for the user to select applying it to their Google calendar. An Email with a link gets lost in their email when they are receiving 100+ emails today.

Good morning Paul, Thank you for your help, forgive my ignorance, but could you provide an example of what, "nested vs added" looks like. I understand that my formula is added.