-
Re: Multi-Parameter Color Ball Formula
You need to have the column type set to visual symbols, which you already have. Write a nested IF formula using the conditions you have mentioned and then convert the column to Formula Column (you ca…2 · -
Re: The new Smartsheet experience
I believe Smartsheet team has heard this loud and clear, and so lets give them some time to address it. Yes, we are not happy with few things UI/UX wise, but let us also keep in mind that the functio…1 · -
Re: Find the Percentage of the Total
Are you saying the formula in the Percentage column =Total@row/40 is not working? Make sure your Percentage column is text/number type and column is formatted to be "Percentage format" (use…1 · -
Re: Equivalent of 'FILTER' function
@Dakota Szumilas What Mike is trying to say is that -- You should select both the Master and the Territory sheets (multiple sheets report) when creating the report and you will be presented with fiel…1 · -
Re: Sum Values in Matrix
All I can say is that, you cannot specify range argument as a matrix (rows and columns), COLLECT expects the range as a column range.1 ·