-
Forms and functions
Hello, It would be smart to be able to add hide field in form with formulas. Actually, forms add new lines, so in a smartsheet where you need formulas you have to add them after. Not very smooth. Right now, to make my smartsheet a tool for users i have to ask them to insert line manually in smartsheet with formulas already…
-
BUG formulas when Inserting a TOP row with a Form
Hi all, Since a few days, there are some issues inserting ROWS with a FORM. see image below, for instance when you insert a row at the top of a sheet, it SHIFTS all the formulas in the entire Sheet ! Any Help is Welcome... Thanks
-
Building Notifications
I want to set a notification when a cell is populated but only one time to let the recipient know the action is in progress, then cease when the action is completed. It seems that my recipient will receive the notification every time a change is made in any column of the row once that cell is populated. My sheet has over…
-
Inventory help.
I am looking to use smartsheet for inventory. I have one item that we stock and I would want to scan the bar code in to record the s/n and when an order prints to be able to scan the bar code removing the item out of inventory. I used the "barcode inventory management" template but it works great for adding inventory but I…
-
Not receiving notifications
Hello everyone, I am fairly new to the Smartsheet app, as well as community. I am having issues with not receiving notifications, when a certain task (column) is populated. I have created a Smartsheet to order materials from outside vendors. There are to be multiple employees adding stuff to this sheet, and one or two…
-
Attachment Library
Anyway, the same attachment can be selected to be attached to a row in another sheet. This is a common problem. We run projects, and upload files to the project sheet. But each project could have several sheets. And the same attachment is required on other sheets as well. Is there a way to have a central area for…
-
Cannot add field to attach files
Hello everyone. I am working on a sheet that will store files sent by third parties. But currently It does not give me the option to place a field to ask for attachments on the form I am working on. I started to use Smartsheet recently, so it can be quite easily to solve this problem, so please be patient. Ty all
-
Rename Attachments / Sort by Date Order of Document?
Good afternoon, I am working in a Smartsheet and the order of attachments (by date) is very important. I need the attachments to be in the order that the documents were modified last, not the date that the documents were attached. If an attachment is missed and you actually want things in date order, you have to remove and…
-
Conditional formatting for a duplicated #
I want to turn a cell red when the # in that cell is a duplicated #. IOW when the # entered has already been entered in a previous cell in that column, I want to turn that cell red. Does anybody know how I could write a conditional formatting rule that would work to accomplish this. thanks, SGF
-
Way to see all tasks assigned to you/others over multiple sheets?
Hi, i am looking to make it so that I or others in the office are able to see all of the tasks assigned/items relevant to them in one place as opposed to having to click on every single sheet. My best understanding is that this is done through reports. However, lets say in one sheet the column is "assigned to" and in…
