-
Form with formula INDEX/MATCH
Hello! I'm trying to see if this is possible. I'm creating a calibration form, but I'd like a specific task duration to be tied to each item, which then populates the due date. For example: Each piece of equipment has a set duration (ie. 365 days). This would be hidden on the form sheet. Once a user submits the form, I'd…
-
Form logic in the mobile app
I searched the forum for an answer to this but I could not find one. I started using the new form logic feature recently (great addition!). When I open my form in the app on my Andriod phone the logic does not work but it does work on my iPad. Am I missing something?? I verified my apps are the most recent update.
-
Form questions
Im new to forms. I am trying to setup an "entered date" that defaults to the date the person makes the request and cannot be changed. The date field does not have a "today" button and no information about how this is done. This should be incredibly easy to do...
-
Expense Report Ideas
I am trying to build an expense report sheet for external attendees that come to trainings. Is there a way to allow them to submit each expenses separately through a form but then somehow automatically group rows together so that we are only paying each person one time for multiple expenses? These people will only attend…
-
Dropdown (Multi Select) Sheet Column In A Form
I have a Smartsheet column configured as a Dropdown (Multi Select) column type and do not have the checkbox ticked for "restrict to dropdown values only". While entering data in the column within the sheet itself I am able to enter values in addition to those provided in the field's value list. However, when I attempt to…
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
Counting number of new rows using Created (Date) and resetting each week
Has anyone posted a formula to use that counts the number of new rows added to a sheet based on the system generated create date? I want to do this and have it reset the count each week, perferrably each Monday. I want to: "Look in the Created (Date) column of Sheet 1 and count if the date [that this row was added] is…
-
Pushing data from Smartsheet to 10000ft
Hello, i am trying to set up a project request form which requires authorisation and once this is recieved it pushes fields through to 10000ft as a new project. I can see how to send info through to Slack and MS Teams, but not 10000ft. Can anybody help? Thanks
-
Set a default value in a pick list column
I have a column in a project tracking smartsheet that shows the status of a project. I would like the parent row for the project to automatically change depending on the status of the child rows. I can do that through the formula: =IF((COUNTIF(CHILDREN(), "Withdrawn") + (COUNTIF(CHILDREN(), "Requested"))) =…
-
Relative Default Date in Forms
I'm looking to do a 'Needed by' date in a form and I would like the default to be a relative Today + 2 weekdays. Anyone found a way to nicely do this? ie. Today is 4/29 , the form will default to 5/1 as the suggested Need by date that can be overridden by the user - say they give us 1week instead - 5/6 that should be good.…