-
Creating a Dashboard Using "Sheet"
Hello all, I'm new to using Smartsheet's and i'm hoping someone can give me advice on how to successfully create a dashboard via "Sheet". The trouble i'm having is finding the correct formula. I want the Dashboard to display the number of invoices submitted by submission branches, for the 1st quarter 2024.
-
Ordering Folders
I am using the "newish" navigation pane with my projects. I have several reports and sheets that a typical user does not need to view or use. I have moved all of those to an "admin" folder. Unfortunately, "admin" puts the folder at the top of the list. Is there a character that I can use to put it at the end of the list…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
-
Copying a row when the row contains certain values but is not a set value.
I have a column that is called Task Name but there are all sorts of titles. I am looking to copy a row to another sheet if it contains, for example, N01-20 or N19-20. Because they are project titles, the Nxx-xx can be any combinations of numbers, but it will start with an N and be followed by the "two digit number-two…
-
Column to column link functionality?
Hi all What I've trying to do is link the primary column from sheet 1 to the primary column in sheet 2 so that when new values are added in sheet 1, they're reflected in sheet 2. I'm currently using cell to cell link, but each time new values are updated, the links need to be as well. I can't find anything about columns in…
-
How can I update a dashboard real-time without end users seeing my edits on the fly?
I'm working on a corporate project in which "everyone" will have access to a dashboard with project updates. I plan to collect updates throughout the month, which requires me to open up filters, look for new projects, add new projects, and updates statuses. I'm worried about how to do this operationally without everyone…
-
Data Shuttle won't run manually or on a schedule after first instance
I've been struggling with this for a day. I am offloading a Sheet to a Google Drive. When I create the workflow in Data Shuttle and click RUN, it runs fine. If I try to do it again, it seems to process the file, but it never updates in on Google drive. I can repeat this over and over, it will only run once. Ive tried…
-
Can I migrate from a eu region acctoun to an us region account? (wrong account and paid creation)
Can I migrate from a eu region acctoun to an us region account? (wrong account and paid creation)
-
Project with Hard Deadline Template
Hello Smartsheet Community! Does anyone have any good examples of how to utilize the project with hard deadlines template? Is there a way that I could take a current project plan that starts with the project kickoff to ends with the project setting in stores and apply the hard deadline template? Ultimately what I would…
-
GPS equipment tracking with Smartsheet
We currently have a 3rd party software that tracks our large equipment via a GPS hardware module and their proprietary software. I am wondering if there would be a way to utilize an open source GPS module and have all the data flow into a sheet in Smartsheet. Ideally I would like to transmit the location (lat and long) of…
