-
Auto Filling a cell from data in another samrtsheet
Good afternoon I am creating a bid invitation sheet and need to list GC bidders per each job (row). * How do I create an autofill for these cells based on a directory I have created? * and once the GC is selected in this cell how do I autofill the column next to it with one of their many estimators at their company that is…
-
Shared Filters Not Working
In one of our sheets I want the ability to "force" users to view a sheet through a filter. We have a lot of rows that are added on a daily basis and I want those rows to be hidden if the completed column has been checked. This makes it easier to navigate the sheet and find the open actions that need to be addressed. So I…
-
Form Search and Auto-populate values
Hello, I have the following project I would like to achieve in Smartsheet if possible. I have a master data sheet with information hard coded. The sheet has a key reference number associated with each assigned task. When a user wants to add a task into the master sheet, they have to open the form and enter a key reference…
-
Forms - How to get them to update a smart sheet?
If anyone can help... I created a form on issue tracking. Went to test the form and it appeared to work fine. However nothing updated in the smart sheet. Why is that? Is there something else I should be doing? Where did the update go? Why is it not posted to the sheet?
-
Card View. Being able to display a lane by Checkbox.
Hi. I have a grid that has a primary column, a few other text/number columns and then 5 Checkbox columns. The primary column is used to identify a staff member, the few other columns are for misc. information and the checkbox columns are setup (5 in total) as the 5 days in a week (M-F). The grid and form works. I am trying…
-
Database of information from one sheet to another
Hi all, I have a sheet that is a "database" of about 400 records. I want other users to be able to input one column of that sheet (Media Company Dropdown) in a form or other sheet and for the next seven columns to autopopulate. Is this possible? Would VLOOKUP be a solution? I've read a few forum posts that said that…
-
How to configure a project assignment and the assignment date and show the rest of the fields diseab
I have a problem. When Smartsheet sends the form on request to an area. I need to know if after receiving a project from a form, to be able to assign a resource and the date of assignment I can only do it from an update? or there are other ways of being able to assign people and date of assignment, automatically without…
-
Spell Check in Free Text Fields on Smartsheet Forms?
Is it a browser setting, or would it come from how the Smartsheet web forms are built, but I would like for a misspelled word to get the red underline when my users go to fill out a form that populates my sheets in Smartsheet. Help?
-
Can't find forms as columns
This is my first day starting with SmartSheet so forgive me if this question is embarrassingly simple but I can't seem to find a video or an article anywhere which explains this. I selected a project management template and dowloaded the PDF instructions. One of the first things it asked me to do was to edit the form…
-
Forms file upload
Hi All I'm new to smartsheets and would like to advice. Is it possible to upload a " Google File " within a form, at the moment I only have the option of uploading from My Computer Thanks for your help in advance Mark
