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'm working on a formula that will return a count based on a matching dates and the word "Quality", but I'm getting the unparseable error. I'm sure it has to do with where I'm putting the ) and ,0 ,1. Here are some that I have tried:
I need help creating a formula that references the "Due in Payroll" column I have which is a series of dates. I would like the formula to look at that date column, and return whichever date in that column is closest to today's date. I've tried several formulas, all come up invalid column type, unparseable invalid…
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…