-
Formula Help
Greetings- I'm struggling with the cross-sheet referencing and need some help with a formula. I want to create a new sheet summarizing the values on a corresponding dropdown menu for the name and # of products we sell. I'd like the total number sold for each dropdown choice displayed on the new sheet. In the screenshot,…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
Hyperlink to a specific row in another sheet?
Is there a way to hyperlink from one sheet to a specific row in another sheet? I want to be able to click on the link to jump from one sheet row to a specific row in another sheet. Thanks, Stan
-
smartsheet API
Greetings Can someone please explain to me how APIs work ? I am not familiar with many of the technical jargons used on the SMARTSHEET API link. I need to update data on my Gantt charts automaticallu instead of manually inputting the numbers and dates. Can APIs be of any help to carry them out ? Can I somehow read and…
-
Filter on Critical Path, Locked Rows, Attachments, and Comments
Hello Community! The title says it all; we've just released a new Row filter criteria that lets you filter on whether a row has or doesn't have the above (title) criteria. More information on this feature is available in the Using Filters to Show or Hide Sheet Data article. You can use this new filter criteria today!
-
Getting our corporate colour pallet loaded in smartsheet
Hi - is there a way to get our corporate brand colours loadeded in SmartSheet as the colours are very limited in the tool today. We also have to export to excel and apply our themes to it. I want to get away from this goining forwrard. Please help!
-
Generate list of recently updated sheets
I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5 I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like: * FinanceSheetXYZ updated Yesterday by John Smith *…
-
Checkbox columns
Hello, I am trying to have a mandatory field in a sheet based on checkboxes. Basically I want 2 columns, one of them will be a checkbox and if that checkbox is selected, I want the second column to be a mandatory field and be filled out. Ideally my second column will be a Yes/No dropdown but I understand this might not be…
-
Row numbers to a dashboard
We monitor the number of requests that come into 3 different Smartsheet forms week over week... i created a dashboard to show the requests within the past 7 days, but i need the rows to tally... even if the row number shows up on the dashboard itself, that works - i can simply see that 45 rows were created in the last…
-
USERS/COLLABORATORS
Why we have a Business plan with 100 users/collaborators and the system is asking me for more licenses when sharing a Workplace with few peoples. Our Business plan has 3 Licenses. account wj@toperbee.com