I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.
I would like to have a form where someone selects one op…
Formulas and Functions2778Dajah
I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files.
Using Smartsheet890Carly Sorensen
Hi. Is it possible to create a dorpdown list that is dependent on the option selected in other column. For example, when I have list of 300 Banks with SWIFT codes . One column is Bank name, another column is SWIFT code. I also have a list …
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…
I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sh…
This article about a SmartSheet competitor, Airtable, has been making the rounds in my little universe of technology products researchers. https://medium.com/@WeWorkUX/the-atomic-unit-of-research-insight-17d619583ba
As user re…
Using Smartsheet173Mariana Almeida
My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet.
The biggest is the inability to create a drop down list that us…
Can you add these features this year?
API & Developers98mark.gipson27746
Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come i…
Has anyone received this error message before? What are the options for large data?
Using Smartsheet291David Skinner
Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified"
Formulas and Functions83lisarae723
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions70KDub618
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down?
Below is the formula in E…
Archived 2017 Posts88Michael.Baker
My team is looking to add a team travel calendar to MS Teams. I'd like to keep the MS Teams tab in the calendar view. What's the best way to easily get the calendar updated with team travel plans staying in calendar view?
How do I hide a row, is there a specific from or sheet template that allows for hiding rows?
I do see that hiding colums is possible, looking for the same functionality but for an individual row.
Archived 2015 Posts3917Sherri Gartner
We have noticed over the last 6 months or so, that there is a persistant bug when using the "highlight changes" feature.
The smartsheet will highlight changes within the given date range. However, it will also highlight other …
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program.
I'm hoping there's a way to automatically track inventory usage base…
Formulas and Functions234@agredling
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be cop…
Formulas and Functions56Brad Huff
For example I have sheet A that has my master list and all components within a "Kit". On sheet B I have multiple kits and would like to reference all the included components. I get that you can link cell to another just like an…
API & Developers177Dean Sund
Good Morning all,
I established an approval workflow with a loop by using this: https://community.smartsheet.com/discussion/how-loop-through-workflow
However, i would like to track the comments of the Approver for example. Sure he can in…
Using Smartsheet143Thimmo Borger
Is there any way at this time to add a photo into the title area of a form?
IE on the one beneath where it says, "SmartSheet Popping Plate" Would there be any way to put a photo there of say a company logo?
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in t…
Formulas and Functions500Allison Caskey
We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process.
Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …
API & Developers120tcalvey
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into S…
Formulas and Functions60MikeCorvin
Am I being dense? I can see ways to automate a reminder based on conditions, but in a sheet with multiple submissions from one person, if I want to remind them ONLY if I haven’t received a recent update, I can’t say “don’t send if.” ?
I'm trying to come up with the formula to dropdown only certain countries if chose certain region.
I have two dropdown columns Region and Country
If chose Region EMEA, country dropdown list will show DE, DK, NO
If chose Region APAC, cou…
Formulas and Functions49seeble
Hello smartsheet community,
Initially I was tracking completed tasks with a "Done" column which would automatically format the row. After needing to add more options like "Cancelled", "In Progress" etc. I op…
Using Smartsheet97Josh Hunsaker
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…
Formulas and Functions330Jess Merritt
My peers setup my profile when I joined Serta Simmons Beddings to get email notification of requests made to add new supplier to Streamline. I am still not receiving the notifications, although my peers are. My profile matches theirs app…
I've read through all the replies on this but have not found the resolution yet
I want to display RYG balls in a new column i created that corresponds to the project Status and Finish Date. The new column Properties is RYG Balls
Formulas and Functions24SherB