-
How to autopopulate % Complete based off of other cells entry
Hello, I am trying to autopopulate % complete based off of other cells YES/NO entries in the sheet. I have 5 criteria to determine if we get to 100% Completion or not: Columns: Paperwork Received - YES (add 20%) NO (add 0%) Samples Received - - YES (add 20%) NO (add 0%) HPCL Received - YES (add 20%) NO (add 0%) Hold…
-
Direct a new form to an old form URL
Hello All, I'm moving to a new sheet with different column headings and different information. I need to keep the old one. I know the workaround will be to save a copy of the old sheet for my archive and use the original sheet to build the new one. But I'd like to start from scratch (in fact, I already have!). I would like…
-
Auto-populating A Form Field
Hello, I currently have a form that asks users to select a product from a dropdown list. Is it possible to auto-populate the email address field so when a product is selected, the email address associated with that product automatically pops-up?
-
therapy caseload/client data tracking... anyone have success with smartsheet?
Hi all, I'm an Occupational therapist for kids with autism. After the pandemic rendered our therapy office paper data filing system obsolete(I couldn't access it from home), I determined to make the move to digital client records Smart sheet seemed like a user friendly option over excel I'm looking for a basic set up that…
-
Use smartsheet data to generate a document that maintains fillable blanks for the recipient
Use: We are using smartsheets to maintain client progress. We have forms that are pdf fillables mapped. We generate these and then email them to the account manager. At that point, the manager still has information to complete ie- other questions on the form that were formatted in acrobat pro to have fillable blanks that…
-
Forms - Logic Question
Hey all, Hoping that someone could help me with a form that I am creating. What I am stuck on is: From a dropdown menu, I have several dates that can be selected. What I am looking to do, is when a date is selected, something will pop up with a due date for the form to be submitted by when that specific date is selected.
-
Merged: Revising the DATE field in forms
This discussion has been merged.
-
Merged: FORM Date Validation relative to another Date field
This discussion has been merged.
-
New Form is not empty?
Hello, Question: I made a form for a smartsheet so people can use it to enter lessons into a register. I use a link in an email reminder so the recipient can open the form from the email. Issue is: When the form opens it is already populated with the previous entry. I am not sure how I am messing this up, but I am looking…
-
Merged: Form Management Automation for Activation or Deactivation
This discussion has been merged.