-
Using Forms for COVID
I'm wondering if anyone is successfully using Smartsheet forms to collect daily self-health checks for employees. I'm looking to create a solution that allows the user to take the survey, and at the conclusion, it would tell them, based on the information just answered, whether they can proceed to work or not, at that…
-
Form submission is not generating an email notification from Smartsheet
Hi, I have two Smart sheets and each have form(s) associated with them. On one Smartsheet, when a user submits a form, I am alerted by an email from Smartsheet. But this functionality does not work on the second Smartsheet. Can you help? Best Regards, Lynn
-
If function
Hi Experts, I tried to use an IF function to create the following output. If Name is Peter and XY is NC than result should be 1,5 If Name is Lenn and XY is NC than result should be 1 same as below for Julia. I start with this: =IF(AND([Name]@row = "Peter", [XY]@row = "NC"), "1,5") it works but as soon as I add another IF…
-
All sheets gone!
I signed up to Smartsheet few years ago after someone shared a Smartsheet with me. I liked the product and later upgraded to the premium version and used it for few years. However, few months ago when the renewal came up - I let the premium subscription lapse as our work came to a halt due to the pandemic with the…
-
Groups inside a form
How can I prepare a group of questionnaires under the heading or anything else? So that when the logic is created all the dialogue box are shown as per the heading or group?
-
Can System Admin Create and own workspaces without a licence?
Hi Think i know the answer but could someone confirm above? Thanks
-
is there a way to create a useable contact list?
Has anyone found a work around for creating a re-useable contact list? Example: I have 180 people in my department and want to be able to have all of them in a contact list drop down that I can use over and over again. There is currently no way to copy a contact list from one field to another, or to select multiple names…
-
Require people outside my organization to log on to access form
Hi, I created a custom form to be filled by a team outside our organization, but I want them to sign in. How do they signup for Smartsheet as free users, to be able to fill in the form. Thank you
-
Need help on creating a specific Email Workflow
I am creating a sheet which has a purpose of collecting a list of students and their job opportunity preference (part-time, full-time, internship), Industry interest (Marketing, Finance, Energy, etc.), Geographic location preference (New York City, Washington DC, Los Angeles, etc.) and their resume/email. I often get…
-
Sharing of files in a folder
How do I setup file sharing so that the person can only add data in one file and have view only functions for all other files within that folder. It looks like the editor -can share role is for the whole folder and cannot be for one file in a folder??
