-
COUNTIF with WIldcards
I have a survey sheet where all columns start with specifc chars: D-, I-, O-. Each contains differing descriptions following the "-". I want to create a sum of all "D-", "I-", etc. disregarding the descriptive text following the "-". I am using COUNTIF([Column1]:[Column X],="D-*") with no luck. Always returns "0" unless I…
-
Simultaneous use of form by multiple users
I am using a form to collect sign up information at an event. We will have multiple computer stations set up with the form. I wanted to ensure that we won't run into any issues with simultaneous usage / submittal of the form by multiple users. Thanks!
-
Using Smartsheet as the only tool vs SharePoint, shared drives and OneNote
Our department is looking at how we file electronically. We have used a combination of OneNote, SharePoint, Shared Drives and we just started using Smartsheet. Smartsheet seems to allow for all communications, files, etc to be stored there. Has anyone moved to using only Smartsheet for everything that has anything to do…
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Restricting access to PII (Personally Identifiable Information) data
I am getting questions about the safeguards in place for PII (personally identifiable information such as names, phone #s, addresses, etc) and wanted to hear how other customers have handled. Where we are seeing leaks is in the alerts, update requests, and send row feature. These features send the entire contents of the…
-
Query String Syntax
I am having an issue with a query string syntax. See below. Trying to populate two fields when I send this out. I actually wish I could populate the form from data in the sheet but i dont think I can. Please take a look I have tried multiple different things Trying to populate an Order Field and a Name field…
-
Weekly Input for multiple data points at multiple sites
We have been tasked to gather weekly meter data: multiple meters (3-10) for each utility (water, electricity, natural gas) at each of the 60 plants. What is the best way to gather multiple data points from mulitple plants all at once? We are unsure how to format this correctly. The plants will have to entrer Meter Name,…
-
Auto Formatting with New Row Entry (via Webform)
Scenerio: Row 1 and Row 2 have a Blue Background for all 6 Columns. I created a webform to add above these 2 rows for all 6 columns. When I submit the webform, the added row does not receive the lower background on it. This use to work, and now for some reason it is not. Let me know if anyone has any fix, thanks!
-
Auto Indent When Using a WebForm
I have some formulas on the 1st row and everything underneath are indented in order for the formulas to work. However, when a new entry comes in via the webform. The new row does not indent automatically. Does anyone have any suggestions? Thank you!
-
Web Form session time
Hello, Is there a save-what-I-have-typed-in function in web form? for example, I didn't finish the web form at once, maybe, I left in the middle of it. When I come back to it, can I still use the same web form, and when I click submit, can this form be submitted successfully? I know this is a strange question, and I…