-
Formulas are not copying to new entries for forms.
Every now and then, new form entries in my sheet will have some or all formulas missing. I add all new entries at the top of my sheets, so there are never any "blank" rows between that and the one below. I have an integration solution set up keying off of some of these formulas, so whenever they fail to copy, that gives me…
-
Strip out @domainname.co.uk from Contact
Hi I have a sheet with a column for 'created by' (for form entries) and need to be able to strip out the @domainname.co.uk text so that I'm just left with the individuals name in a separate column. Ideally, I would also like to add a space between firstname.lastname at the same time. example:…
-
Whoaou !! whats happening with the Forms ???
Since 2 days when I add a row on the top using a Form the sheets are disorganized and the formulas are destroyed...am I the only person to have the issue ? When I had by the bottum, the formulas are not copied... It was workin until last week My sheet is in place since sevral week and got 500 rows No answer from the…
-
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
-
How to hide rows on a list?
Hello everyone, I am on the trial version, testing to see if it will work for my company. I loaded a spreadsheet from Google Sheet, and I am trying to hide some rows. I clicked everywhere and wasn't able to find. Would somebody please help me? Super thanks in advance!
-
Auto Flagging Yes or No answers
Hey everyone! This is my first post on smartsheet, so please bear with me. I'm trying to build a Production Report. I'd like the Red Flag to turn on whenever the "Was Production Met" column says "No". This is my current formula: =IF([Was Production Met?]1 = 0, 1). I can make it work with a checkbox, but no luck with yes or…
-
Create JitBit Ticket When New Hire Form is Submitted
Hi all, I'm very new at Smartsheets, and have just created a New Hire Form and I would like it to create a JitBit ticket when the form is submitted. Is this possible? Thanks in advance!
-
Symbol Column description
Can the description of each symbol be changed? Thank you!
-
Managing form-generated sheets
Hello: I am new to Smartsheets. We have been using a form-generated Smartsheet to track decisions about new acquisitions. The Smartsheet is getting so many rows on it that it is difficult for staff to use. I'd like to move rejected resources to another tab, and move decisions made more than 2 years ago to another tab. Is…
-
Link to PDF file on Smart Sheet Form
Hello, Is it possible to make a nice hyperlink for a PDF on my smartsheet form? The current link I have is http://www.DOMAINNAMEHERE.com/mbk/RA Submission - English.pdf My first thought was to put an HTML tag in the form, but that didn't work. When I search the community forum, most of the posts talk about hyperlinks on…