Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
NOT include "complete" or "removed" in my CountIfsIn Formulas and FunctionsI am trying to get the count if my acquisition New has a go live date between 2 dates but not include those that have been marked as complete or removed. Here is the formula I currently have, I'm getting an incomplete argument. =COUNTIFS…
-
Workflow or function that alerts me when something repeatsIn Formulas and FunctionsI would like to set up an automation or function that alerts me when something is repeated in a sheet 3 times in a 30-day period. The trigger could be taken from a drop down menu, i.e the location "ABC Lane" has been chosen in a …Answered - Pending Review 2 views 8 comments 0 points Most recent by Jamie Paraf Formulas and Functions
-
Forms and Automation with Contact Type CellIn Using SmartsheetI want to have clients submit a form which includes their name and contact information, and then set recurring update requests to be sent to their emails. I tried to accomplish this by creating two different (Text type) fields on the form,…Answered - Pending Review 2 views 1 comment 0 points Most recent by Kimberly Loveless Using Smartsheet
-
How to return a value from a reference sheet based on two columns in target sheetIn Formulas and FunctionsI am trying to use two columns in a target sheet to return a value from a reference sheet. My formula is =JOIN(COLLECT({Designated Recipient Focus Area}, {Designated Recipient Focus Area 1}, @cell = [Focus Area]@row, {Designated Recipien…
-
COUNTIFS on checkbox columns with multiple criteriaIn Formulas and FunctionsIs there a way to have a countifs formula on multiple columns? I want to count the cells where PM=Alex and there's a checkbox in the last 4 columns. =COUNTIFS(PM:PM, "Alex", [Agenda 6/7/21]:[Agenda 6/7/21], 1, [Min 6/7/21]:[Min…
-
Referencing Multiple Columns in another sheet to Match a Location and Date Range to a ProjectIn Formulas and FunctionsSo I have been looking through the community for a while and have seen a couple solutions mildly similar to what I am looking to do, but can't quite get it right. Feel free to link me to another solution if you feel it would solve this pro…
-
Counting Instances Across SheetsIn Formulas and FunctionsI am building a dashboard for each of the colleges at my university. I originally created a Smartsheet for each college that lists all of the courses in each of the programs in the college, documenting whether or not we have a course maste…
-
Master Contact List for use across sheets in a workspaceIn Using SmartsheetI have 16 grids that all use a Contact List with 23 of the same client contacts. (1) its a HUGE waste of time to have to populate 23 contacts into a list 16 times and (2) every time a new person joins or leaves the team, I have to go into…
-
How to combine multiple rows of data into one row based off of one cell value.In Formulas and FunctionsHello Smartsheet's community! I am back with another question. I have a database that holds the tracking of employee trainings. The training structure is in tiers and after each completed tier they fill out a form. The raw data from this …
-
Using forms and multiple rowsIn Using SmartsheetHello, I have created a form for my team to enter data to populate on a master sheet. We will have multiple part#'s and QTY's per request, however, I cannot find a way to have forms split those into separate rows. Is there a way to have a…
