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)
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
I am struggling to create a formula for the RYG symbols. I would like to base it off percentage complete and due date. What I am looking for is: Red = Due date <2 days less than .90 and anything past due Yellow = Due date < 4 days less than .50 All other green
