Sign in to join the conversation:
Hi Smartsheet community,
As an Admin, I setup a dashboard with a chart showing data with $ signs.
A viewer sees the same dashboard chart with US$ signs.
Is there a way for the viewer to see only $?
Thanks for any suggestions!
Dee
Hi Dee—
This is dependent on their Regional Settings in their account. There isn't a way for you to change this on your end.
(More on regional settings here: https://help.smartsheet.com/articles/796268-adjusting-personal-settings)
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
I have a checkbox column [H-SD (Added)[ with this formula: =IF([H-Supplier Type]@row = "Individual", IF(COUNTIF({SD-EmailPrimary}, [Email (Primary)]@row ) > 0, 1, 0), IF(COUNTIF({SD-EmailPrimary}, [Organization (Email)]@row ) > 0, 1, 0)) In another column, i want to evaluate if that column is checked or not, so I put this…
I have a sheet where I query 14 other sheets to collect all sorts of data (unique values from sheet into a column) and in another column I use an Index distinct collect to get all the unique value from those 14 columns, this is the 'Index' column. At some point a user will want to generate a certificate associted with the…