-
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.…
-
Logical Condition with forms
Hi, Can we make a logical condition with forms? For example, I have the first selection for Gender and if someone select "male" or "female", it will show different forms for each selection.
-
Update request form after completion/submit not triggering workflow
Hi, I'm quite new to workflow and I'm trying to achieve the following: A document need to be signed by 2 signatories, signatory 1 received an automated update request from workflow 1 which works well. I want workflow 2 to automatically request an update from signatory 2 when signatory 1 has completed his task. I tried…
-
Forms with Workflow
Hi, Is it possible to creare forms with workflow e.g if I click "fruits" I will se options "Apples, Oranges..." If I click "Veg" I will se options "Tomato, Onion..." I would like to create Sales tool for my team so they can go step by step with sales process without missing steps. (Maybe you no other tools for doing that).…
-
Conditional Sections of a form
Hi, Is there any way i can create a form so that, if a certain field is selected from a dropdown menu another field then appears needing to be filled out? Any clarification needed feel free to let me know :) Cheers
-
Intake Forms: Dynamic/conditional fields or hidden links?
Hi! I have not found this topic discussed yet. We'd like to do a couple of things with our intake forms. 1. Make the intake fields conditional. Some surveys are set up so that what you chose in field A. will affect what you see for the fields following it. Like "What pet do you have?" If you choose "Cat" the next field…
-
Limiting the Quantity Selection on A Web Form
Hello! I have a form that allows users to select up to 5 types of shirts. I want to be able to limit the amount. So if for the green shit they select 3 shirts, for the red shirts I want them to only be able to select up to 2, and that would meet the 5 count. Does anyone have an idea on how I can do that?
