Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Formulas
Discussion List
-
First post 01/24/20,Last post 01/24/20I would like to enter a formula into Sheet Summary that will show the last time a sheet was edited by a specific person. That person is identified on every row in an "Assigned To" column. I have both the Modified and Modified By …Formulas and Functions60M. David -
First post 01/24/20,Last post 01/24/20Hello SS Community, I'm trying to count the number of instances two values appear together in a cell. From the following example, I would like to count how often "Contractor" and "Vendor" appear together, and furthermo…Formulas and Functions60Yogin Bhatti
-
First post 01/24/20,Last post 01/24/20Hello, I'm trying to count the number of cells that have a date in the year 2020. This is the formula that is returning "0" which is incorrect: =COUNTIFS([Column 1]:[Column 1], <=DATE(2020, 12, 31), [Column 1]:[Column 1], &g…Formulas and Functions122Jenna Corso
-
First post 01/17/20,Last post 01/24/20Hi team, I'm using Placeholders in a workflow to generate individual emails for an update request. Although the same individual received the update, they will forward as needed, so I need to ensure each update request for the day doesn't …Formulas and Functions3710Rob Kozak
-
Creating a widgetAnsweredFirst post 01/24/20,Last post 01/24/20Hi, I need assistance in creating a widget for a dashboard. So basically I have got a sheet with close to 2000 rows and each of those rows have action owners, due dates, etc. I would like to create a widget that would show when the actions…Formulas and Functions143sahilhq
-
Answered Jaye Tatone 42 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/24/20Wondering if anybody else is experiencing this - I have performed this scenario hundreds of times without issue so wondering what's up! I have a formula based on full Column:Column ranges. The criteria ranges are set with $, the range to s…Formulas and Functions423Jaye Tatone -
averageif with multiple criteriaAccepted AnswerAccepted Answer taylor.thompson89836 25 views 3 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/23/20,Last post 01/24/20I am trying to find the average of time in position (demographics range 1)when the job class (demographics range 3) is manager or higher. I'm currently using =avg(collect to try to specify the multiple criteria but am getting a #divide by …Formulas and Functions253taylor.thompson89836
-
Need assistance with a formulaAnsweredAnswered Nikhil Chawla 23 views 3 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/23/20,Last post 01/24/20Hello, I am using the below formula to count the number of rows where 140R was checked previous month. This formula was working perfectly fine until this month when the year changed. How can I fix this formula where previous month should b…Formulas and Functions233Nikhil Chawla
-
Need a formula for counting information based on dateAccepted AnswerAccepted Answer Jona Gjylameti 16 views 6 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/23/20,Last post 01/24/20Hello, I need a formula that can help me calculate the sum within a column based on date. Not sure if this can be achieved. We are updating information on a weekly basis and I have different rows for the same date. I need a formula to give…Formulas and Functions166Jona Gjylameti
-
Answered Edgar Alvarado García 19 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/23/20,Last post 01/24/20Hi there, In a sheet I've few cells that have formulas, columns were those cells are aren't lock, however the users cannot overwrite the formulas, any idea why it may happen? The idea was to create formulas as a guidance but editors shoul…Formulas and Functions193Edgar Alvarado García
-
First post 01/23/20,Last post 01/24/20Hello, I have two separate column Status and Due Date and I'm looking to create a formula on the sheet summary for the amount of items that are due today and past due. Is there a way to create one?Formulas and Functions141Heidi Ng
-
First post 08/28/19,Last post 01/24/20Sheet 1: Work Scheduled (number of work units scheduled in a given month) Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month) I would like to multiply a cell from Sheet 2 with the…Formulas and Functions25717JoeS
-
Text change based on value of numberAccepted AnswerAccepted Answer Kelly Buse 17 views 4 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 01/22/20,Last post 01/23/20Hi All, I was hoping to create a formula that changes the text of a cell based on the number in another cell. Here is what I'm trying to make the cell display at each value range: Value is under or equal to 20 - Cell to display "N/A…Using Smartsheet174Kelly Buse
-
Formula in % Allocation Column?UnansweredFirst post 01/23/20,Last post 01/23/20I am certain this has been asked either currently or in the past, but is the capability to include a formula in the % Allocation column on the product roadmap? Right now, I have a column entitled "% Alloc Calc" next to the "…Formulas and Functions130Guy Behanna -
Automatic ticket numbering by locationAccepted AnswerAccepted Answer M. David 33 views 11 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20Hello. I worked with someone on a previous discussion, but for some reason cannot locate it now. I have one data base file with the work orders from many different community locations. I wanted a solution for the Work Order Number to be a …Formulas and Functions3311M. David
-
Answered Sean Taber 165 views 18 comments 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 06/18/18,Last post 01/23/20Hello, I'm trying to calculate the average number of days but only for columns that meet the criteria. I have a formula that is calculating the networkdays between two dates. This column is called Implementation Time (Days) - BD. I am no…Formulas and Functions16518Sean Taber
-
Formula to average a range in another sheet corresponding to cells that contain parts of textAccepted AnswerAccepted Answer lhumphrey 16 views 3 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20I can't seem to beat this formula. I've tried COUNTIF, COLLECT, CONTAINS, and when I'm not getting an error I'm getting 0. I want to see the average of successful deliveries below for all Up to Date emails in Q1. In the sheet I'm working w…Formulas and Functions163lhumphrey
-
First post 01/22/20,Last post 01/23/20Hello, I'm trying to calculate average work days that each command takes to return a request. However, it has to meet several other stipulations. -"Type of Request" has to include "FOIA" (drop-down column multi-select) …Formulas and Functions255fennerb
-
First post 12/20/18,Last post 01/23/20I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific da…Formulas and Functions978CamCrichton
-
Answered Kelly Buse 44 views 11 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/18/19,Last post 01/23/20Hello, Another request for information! I have a parent status ball that I would like to change color based on the 2 deadline status balls and the dominant completion ball (i.e. row 1 & row 2 - then row 3 being the dominant ball). The…Formulas and Functions4411Kelly Buse
-
First post 01/23/20,Last post 01/23/20The column name is [Task] and a cell value called "Project Details" is located somewhere in the column. Their children is project 1, project2, ... etc.... I want to count the number of children under "Project Details". …Formulas and Functions121Chuen
-
Flag column based on date & other criteriaAccepted AnswerAccepted Answer [email protected] Seattle 17 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20I'm trying to figure out how to set up an alert to automatically notify someone if the entry row hasn't met criteria (checkbox) within 5 days. I was thinking about creating a flag column that kicks off an email alert but I can't figure out…Formulas and Functions173[email protected] Seattle -
Accepted Answer Justin Runner 43 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/21/20,Last post 01/23/20I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format.…Formulas and Functions437Justin Runner
-
First post 05/17/19,Last post 01/23/20Hey Is it possible to have the the drop-down list of a column changed based on the value of another column? Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is se…Formulas and Functions31416[email protected]
-
SUM totals of VLOOKUPAccepted AnswerAccepted Answer @SPark 23 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/22/20Looking for help on a formula. I need the Forecast Adjustment column on (A) to add all amounts pulling (B). These should total $13,416.67, however, it it showing as $5,416.67. Please help! How do I change the formula to sum the VLOOKUPS? …Formulas and Functions233@SPark
-
Help with an IF/AND/OR formulaAccepted AnswerAccepted Answer Jenna Corso 29 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/22/20Hello, I am trying to write a formula to return today's date when all of the following are met: Column 1 is not blank Column 2 is not blank Column 3 is either Kangaroo or Platypus If any of these is untrue, then I would like the cell to…Formulas and Functions293Jenna Corso
-
First post 01/20/20,Last post 01/22/20I work with large data sets on parts (60,000 SKUs) and I have a form and workflow for processing special pricing requests from our field. I'm curious if I can house the prices on an external excel file or sharepoint and pull in the pricing…Using Smartsheet301Nolan Schmidt
-
Nest if/or formulaAnsweredAnswered raymond.j.riosiii94806 24 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/22/20Hi Community, I need your help... I'm trying to create a formula that captures "No Action Taken". The individual IF Statements are as follows: If [Flu Vaccination Date] is "Blank" OR If [Flu Vaccination Date] is "…Formulas and Functions241raymond.j.riosiii94806
-
First post 09/18/19,Last post 01/22/20I’m working on a SUMIFS formula to add/sum numbers in 2 or more separate cells based on a checkbox input in 2 or more other cells. I’m able to do so only if the number columns and the checkbox columns are next to another. Is there a way …Formulas and Functions214Sam Gold
-
First post 11/01/19,Last post 01/22/20I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I hav…Formulas and Functions387Brian Lynch
