-
Copy some columns from rows to another sheet
This discussion was created from comments split from: Can one form link to two sheets?.
-
How to auto-create a new set of rows once criteria is met?
Hello, I want the following columns to auto-create (with the filled in colors as well) below the already created ones every time "SITE" gets filled in. Do I use a formula, conditional formatting, or some other way? Thank you in advance for the help!!
-
Guest access: How to audit which user added whom to which document?
Hello, After having downloaded a User Type Report, i discovered, with some alarm, that 3 individuals from a competitor have guest access to one asset in our Smartsheet instance. Questions: How can i find out which access they have access to? How can i find out which user granted them access? How can i monitor or block the…
-
Business Plan
Hello, I purchased the Business Plan for our location. I created workflows for people to approve revisions. However, some people are not receiving the auto email that is initiated by the workflow. I think I have the right plan. I shared the workspace with this individual. What could be other reasons for them not receiving…
-
Start and end times on calendar app and calendar view
Ask: Allow start and end TIMES on the Calendar app and Calendar view to help with scheduling (not just start and end dates) Reason: Our team host and manages a bunch of events, some that span multiple days, but many that are single-day or multi-hour events(both online or in-person events.) We use SS to intake all the…
-
Formula problem
Hi! Before I start, I want to say that I'm still fairly new with formulas, so it's very very possible that this error just might need a slight fix, but I need a bit more assistance with what I'm specifically doing wrong here to get a better grasp of formulas. I'm trying to get a sum of how many tasks my vendor has…
-
Grouping in reports based on 4 variables
Hi Community Trying to work out best way to produce a report based on 4 variables…which is just one more than the max in reports. I can't be the first one to have this conundrum and I would be keen to understand how others have resolved it. Columns, in the hierarchy I would like to report are:…
-
How to get user details from SSO login page? from Active directory
When a user submits a form, we need to capture their name, email, title, department, etc. Since we are using SSO and it's connected to Active Directory, these details can potentially be filled in a sheet along with the created by column (records the email)
-
Average of values if criteria is met in two other columns
Hello, I am trying to determine the average of values in one column (Days Open) if criteria in two other columns is met: (Date Closed) is from last month (Facility Name) is a specific dropdown option from this column I can calculate average based upon date closed being from last month, but adding in the second criteria…
-
Form submission error
After submitting the form, it initially displays a successful submission message. However, I later see the following error:
