-
Importing New Project and Having it automatically added to our drop down menu in forms
Good evening We have forms we created where one of our form entries is the name of the project. When we create a new project in smartsheet how can we make it so that the project is automatically included in the form dropdown so that we do not have to manually add the project to the drop down of every form? Thank you
-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Forms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
COUNTIf on the Created (Date) Column
Hello We currently enter data onto a sheet via a webform and I have the system generated created date column added in. I would like calculate the amount of entries from the current day so that I can then use that calculation on a dashboard. I've tried a couple of formulae but nothing is working for me. I would like to…
-
Best practice sharing of links to forms
Hi I am ready to share several Smartsheet forms with my entire organisation (and some external consultants) - currently less than a dozen people - but growing quickly. I am currently the only licenced Smartsheet user. I only want to share the links to the forms, not their respective sheets, to the entire organisation. I am…
-
Formula to track % complete of a fabircation component in a row
Good evening, I will try and explain this without messing up * We are using smartsheet to track fabrication of product * each row is an item we fabricate * each item has a budgeted amount of time per task designated in a column * they are python, fit up , weld, unload, and admin * the sum of alloted time is *…
-
Using Contact Lists within a Form
Can we use a contact list within a Form and allow multiple individuals to be selected like when working within the sheet itself?
-
Formula Auto populate
Hi, I am facing a challenge..when I submit a new form the formula is not auto populated in that row..Please advice. moreever, I am using a IF error formula this does not show blank like its does in Excel IFERROR(IF(VLOOKUP([ES_Code]1, {Lookup Sheet Range 1}, 7, 0) = [Audit fees are denominated in this currency]1, "Yes",…
-
Mandatory Fields
Is there a way to make "Send me a copy of my responses" mandatory/a required field?
-
Is it possible to hyperlink text in a form.
This would allow the user to access additional information when completing the form. I have placed a link to some information in another sheet but the link is long. I know there are applications that shorten urls but I would prefer to hyperlink the text.
