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 have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…
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…
