-
Countifs with Multiple Criteria
Hi - I need assistance with building a =COUNTIFS formula with multiple criteria. Here is my current equation (that I am getting a '0' on) Current Equation: =COUNTIFS({B23 Delegation Registration Status Region}, "SOAF", {B23 Delegation Registration Status Registration G}, "Athlete" + "Unified Partner" + "Medical Staff" +…
-
Having two currencies in one sheet
I currently manage vendors in Japan but need to also have currency in dollar for our finance/accounting in the US. I think the only current option is to change the whole account setting to change the currency, but that will prevent me from having two currencies, and will also change the entire setting to Japanese. Is there…
-
Shared Sheet/ Free User - Initial Log In & Password Creation
Hi, Does anyone have initial step by step instructions/screenshots for a free user who has been shared a sheet and is their first time logging in? What are the initial create password steps? What do the screens look like? I don't want everyone creating trial accounts and this is that is happening today as they are getting…
-
Hierarchical Workspaces and/or More Sharing Options
I currently have an issue where I would like to share capabilities for certain folders to some and it doesn't seem like it has the capability to do that. Currently, I can share the overall workspace with everyone or certain sheets/reports/dashboards within the folders, but it is not easy to get a natural hierarchy with…
-
Sorting Favorites
Hello - Is there a way to sort order of the items that appear in the Favorites section? I don't see the 'Pin to Top' option in Favorites and do not see a way to drag sheets to the top that I would like to appear first. Thanks!
-
UDF / User defined Fields for SysAdmins
I propose that you add a few extra fields that can be used by SysAdmins when provisioning users. There you could specify budget numbers, country of origin, etc. as needed to administer Smartsheet more easily. Today, we have to capture that data in a request form. Then, export the user list and merge with our form data to…
-
Smartsheet's Dynamic View blocked in China
Hi, My team and I set up a process to request updates to our partners in mainland China using Dynamic View. Two weeks ago, we started to receive notifications from our partners that they can't create their Smartsheet accounts to access the Dynamic View, or even worst, those who were able to set up their account 1 or 2…
-
Splitting One Account Into Multiple Accounts
To better manage our licenses as our multi-division company grows, I have been asked to create a new account for our second division, of which I am a part of. However, I am a user of our one and only current Smartsheets account. How can I go about creating a new account, and then moving my Sheets over to that new account?…
-
User icons grey out
Hello, We've notice that about half our users no longer have their initials show up as part of their user icons, and instead these appear to be grey out. All of them are still active and we have not changed anything. Anybody else have this issue and a fix? Cheers, Atish