-
Forms duration stamp
Is there a way to add a START and END timestamp to the Form/Sheet that will enable me to determine the duration it has taken for each respondent to complete the form?
-
Working Days Configuration for an Organization
Hello, Working days and non-working days are configurable on sheet-level and account-level, but I wonder whether we can configure that on the organization-level. I want to set the default non-working days and public holidays for my organization then let my team members edit their own paid holidays on their accounts. How…
-
Best practices when dealing with large amounts of reports
Good afternoon everyone, I was curious to know what everyone's best practices are when it comes to managing a large number of reports and how to implement holistic changes? We have dashboards designed for multiple locations and in those dashboards are reports that are filtering content from a sheet, filtered to those…
-
VLOOKUP with Duplicate Data
I have a master sheet that may have duplicated column data, like: Client Name | Status (dropdown) | Delivery Date | Feature (checkbox) Client A | Rescheduled | 2/5/2020 | 0 Client B | Postponed | 2/12/2020 | 1 Client A | Confirmed | 3/17/2020 | 1 Client C | Requested | | 0 I have a sheet I'm using as a template to create…
-
Need assistance asking people who haven't responded to a form to fill it out.
I have two sheets. One with contact information and another with the fields for a form. I have a formulated column in the contact sheet that compares information to the form sheet and determines if the person in the row, or a representative from their company, filled out the form, basically like a V lookup. My question is…
-
IF / CONTAINS using a range
Have an issue I thought I had resolved, but ... I have a sheet that has two relevant data ranges: Range 1 = a single column that specifies a Content Type for each row item. There are 7 possible Content Types: Data Sheet, Ordering Guide, BDM, TDM, Demo, Learning Map, Proposal Range 2 = 15 columns that contain a Product…
-
Summary Report - COUNTIF of multi-selection columns
I love the way a Summary Report can kinda be a poor man's pivot table within Smartsheet, and it works really well, up until you try to do conditional counts of columns with multiple selections. See below. What's happening here is I want to allow a COUNTIFS when a person is chosen, and count the number of instances data…
-
Nested if/then/and/or???
Hello out there, attaching a screenshot for reference. I'm trying to get the far right column ("Completely Processed") to check under a series of different circumstances: 'Check Cut to Vendor' box MUST be checked for all cases If none of the 'outside $$' boxes are checked and 'Check Cut to Vendor' is cut, then the…
-
Automated alert containing a form to contacts outside of contact list in a sheet
Smartsheet Community, I am trying to create an automated workflow that will alert hypothetical meeting participants with an additional message containing a separate Smartsheet form link. However, I am receiving an error message that some contacts (emails) are not being notified in my inbox. These contacts are not part of…
-
How can I compare two date columns in an automated workflow?
Hi! I want to create an automated workflow which copies rows where two date columns are not equal to another sheet, how can I do this?
