-
dropdown menu in a column in webform
hello everyone i am brand new user in this community trying to familar with this software. so far looks very promising. i have a question like how to make multy forms in one web form like i want to generate form in which in second line there should be multy option to select one and then under neath line will change…
-
Counting Rows
I have a list of projects divided into sections. Each section can have projects that have sub projects. When I use this formula on a section header ="Current(" +COUNT(CHILDREN()) + ")" my result looks like this: Current (24). However, the count does not include the sub tasks. How can I write the formula so that it will…
-
Exporting data into a form document
Good afternoon, I've been tasked with exporting data from Smartsheet into a document. The form field ability in Google Docs gives a good format with the fields, but we're needing a way to have several rows of data displayed on one page instead of one page for each row of data. Is there another way to integrate the data in…
-
"Master" or "Global" Sheet
I am new to Smartsheet and am using the 30 day version to determine if this app will do what I need. Two questions I have is in RE: to the Sheet. I run a PMO and have 12 PMs. 1.) Can I create a Master or Global Sheet and lock it down so the PMs use that sheet I have created which has specific Milestones, Q-Gates and Phases…
-
Love the "Freeze" pane option!
We just started using this option, as we have 71 columns in a particular sheet and scrolling back and forth was becoming quite cumbersome and inefficient. We put our three most important columns at the front of the sheet and the the freeze pane in place at the end of the third column. So far it's been noted as a very good…
-
Web forms and formulas
Good afternoon, I have a simple sheet for a balance sheet, and I'm needing to know if there's a way for the web form submission to be included in the formula in my sheet. The last row & column of the sheet houses the formula from previous lines, but when the web form submission is added, it goes to a new row, not the last…
-
Formula help - if cell is blank, checkmark cannot be checked
Brain cells are missing. I've looked through the formula examples and can't seem to put together the formula I need. We have a column that needs to have text in it before the Checkmark column should be marked with a check. Here's the scenario: IF column B is empty, checkbox cannot be checked. This will help our team…
-
Excel spreadsheet with calendar and schedule
Good afternoon, I hope someone could please give me some ideas if it's at all possible to do with smartsheet or in excel??? I have an excel spreadsheet that was created by a professional. I'll try to explain the information it has on it and what I'd like to do with it. It has the date, Hebrew date, and then in in many…
-
How do I add google docs functionality to smartsheet ?
It does not appear in my drop down menu nor am I able to add it under the App tab in settings. Many Thanks
-
Adding current location to Web Form from mobile device
Hi Everybody! Health care providers are using WebForms to submit invoices from mobile units (RVs). Since the location of the RVs change (and we're in NY so addresses = intersections <> map-friendly), is there any way to add location from the mobile device being used to submit the Web Form? Apologies in advance if this…