-
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.
Situation:
I would like to have a form where someone selects one op…
Formulas and Functions2778
Dajah
-
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.
Savin…
Using Smartsheet890
Carly 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 …
Using Smartsheet164
DIV
-
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…
Using Smartsheet95
Shah_0614
-
HI,
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…
Using Smartsheet636
Dynamics
-
Hi folks,
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 Smartsheet173
Mariana 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…
Using Smartsheet682
kaitlin
-
Can you add these features this year?
API & Developers98
mark.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…
Using Smartsheet268
RossL
-
Has anyone received this error message before? What are the options for large data?
(Image)
Using Smartsheet291
David Skinner
-
Hi everyone!
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"
Here's …
Formulas and Functions83
lisarae723
-
Hi All,
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 Functions70
KDub618
-
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 Posts88
Michael.Baker
-
Hi.
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?
Thanks,…
Using Smartsheet95
marthapapania
-
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 Posts3917
Sherri 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 …
Using Smartsheet17
murray.ashmole
-
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 Functions56
Brad 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 & Developers177
Dean 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 Smartsheet143
Thimmo 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?
(Image)
Using Smartsheet39
MikeCorvin
-
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 Functions500
Allison Caskey
-
Hello All,
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 & Developers120
tcalvey
-
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 Functions60
MikeCorvin
-
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 c…
Using Smartsheet30
smartsweet
-
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 Functions49
seeble
-
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 Smartsheet97
Josh 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 Functions330
Jess 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…
Using Smartsheet40
dmonkou105071
-
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
The for…
Formulas and Functions24
SherB
