-
Hello from Jo based in Australia
Hi everyone - Looking forward to becoming an active member of this community. My career is in MedTech and new business startups, specifically in Sales Leadership/Management and Business Development. Introduced to Smartsheet 18 months and am keen to transition into PM. Looking forward to learning more and would appreciate…
-
Assigned To shows email address not name
When I setup the contact in My Smartsheet Contacts I include the "Name" and "email address", yet when I go to assign the person to the "Assigned To" column sometimes it only shows the email address and not the name. We have a small team and I just want to see "Mary" in my "Assigned To", not "Mary.Jones@abc.com"
-
IF Cell Contains This Text VLOOKUP
Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspection I want this formula to work with any options from the drop-down menu with the letter completed. This is what I have so…
-
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!
-
Customizable Banner Messaging to Subscribers
It would be great if we could customize the banner displayed within sheets as done by Smartsheet to market new features so that SysAdmins could message to their users without the need to do by emails. Examples: Renewal survey is about to launch, Did you know you can go to our company resource dashboard by doing xxxx,…
-
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…
