-
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.
-
Alerts for sheets with web forms
Hi everyone I was wondering if there is a way to set up an alert when a sheet is approaching the limit of entries. ( data is coming in thorough web forms) Thanks! Noemi
