-
Index and Match
Hi , How to use Index and Match function in SS.Please advise with an example
-
Already submitted webform
Is there a way that a person filling out a webform can "call up" the submitted form and make changes and resubmit?
-
Having Trouble with SUMIFS
I'm trying to create a condition based upon user submitted data for over budget flight requests. If the flight type is a One-Way, then whatever the pre-tax amount should be subtracted by the budget amount to give me the over budget amount. This formula is =SUMIFS([Flight Cost (Pre-Tax)]1 - 350, [Flight Type]1, "One-Way")…
-
Counting the amount of entries from from entries
Hi, is it possible to capture the amount of entries that have come in from a form? the form is constantly being populated so i am looking for a live number if possible? Any help appreciated. thank you Dave
-
adding multiple approval stages for request form
Hi, I need to create a service request form that goes through different approval stages in our company. Stage 1 would be this: Co-worker fills out the request form which then goes to our accounts payable guy (AP) to check the budget. Stage 2: AP then decides if there's enough budget. If not, the co-worker receives a…
-
Multiple Entries per One Form
I am creating a form that will be sent to out and will need to be populated with numerous lines of data following the same format. I have read previous posts about Smart Sheets inability to allow one form to populate many row. Is this still the care or has the capability been added? Basically I am trying to create a…
-
Check out/check in - Validating an inventory.
Ok, so I'm trying to use Smartsheet as part of our employee move process. Basically, in the past we've use a paper form to inventory what a person has (PC, monitors, chair, boxes, etc) and then use the same inventory to validate that the correct items arrive at the new location. So, I've created a sheet that will capture…
-
Webform Error message - can anyone help?
Hello , We use smartsheet webforms for daily reports for some of our volunteer workers..this works fine when the forms are filled out on a computer, however when filled out in our school app and submitted, they get the attached error message saying "this form is not found". Despite this, we still receive the reports into…
-
Help needed with formulas - paid work opportunity!
Hi everyone, My colleague and I are new to SmartSheet and we are having some issues with a few formulas and we can't quite work out what has happened. We are offering paid work at an hourly rate for someone to join our team to help troubleshoot and fix our SmartSheets issues. If you're interested, please let me know!…
-
Building sheets that talk to each other
Hello, I have two sheets I would like to reference data to and from and I understand how to us the =VLookup option BUT what I cant seem to get it to work. I basically want one sheet that our shipping team updates to automatically update another sheet my purchasing team uses. The columns have dates and check boxes so when…