-
Hyperlink to external drive
Hi all, I'm looking for a way to enter a hyperlink from another local shared drive in a Smartsheet cell. Is this somehow possible? Thx for your help! Warm regards, Gonnie
-
Average of a drop downbox item
Hello, I am currently working on a project that involves a Dropdown box that has 3 options, Not Started, In-progress and Completed. However, I would like to get the average status of the project, and the the formula I am currently using doesn't seem to be working properly so I was wondering if I could have some help. This…
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
-
Sorting Filtered Sheet
Does anyone know if there is a way that you can sort a filtered sheet without altering the sheet structure across the board? Thanking you in advance.
-
My Cell is Red for NO Reason!
The title says it all. I have a cell, inside a column (obviously lol), and its red. I have no idea whatsoever why it is red. Is it mad at me? (lol okay, no more jokes I promise) I do have lots of conditional formatting in my sheet, and in this column too, but the other cells are behaving as expected. I tried satisfying the…
-
Inserting Barcodes
So - I see the new bar code functionality. However, I don't see information that describes how you would insert a bar code into a sheet (I assume it has to be done so that the search function works). This may be super simple, but I'm a bit lost. 1. What is the best way to generate one? 2. How do you transfer the bar code…
-
Copying Alerts & Actions from sheet to sheet
Hi all, I have a set of 5 "Alerts & Actions" that I need to set up on 32 different sheets. Is there a way of "copy and paste" those rules, instead of manually set them up on each sheet? Thank you.
-
FILTER
Hi, Im struggling to find a way to filter and select.. Just as in excel, i want to be able to filter where it shows all say companies and then tick a company name to allow me to see all the entries starting with that company name. Hope this makes sense
-
Date changes to tomorrow after 5pm
Hello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date column to run reports on what equipment were checked out vs. available. We discovered…
-
Looking for some guidance: need recommendation on the best template to use with client to track feed
Hi to all and thanks for considering my request. We're somewhat new to SS, have looked at all templates without finding a product evaluation feedback form that would allow users to share issues, insight, feature requests and help requests for a 30 day product evaluation period. I'm not expecting to find the EXACT template,…