Want to practice working with formulas directly in Smartsheet?
Check out the
Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Product questions?
Ask it here! The community's got your back.
Discussion List
Calculating Schedule Health - RYBG
Hello, I am a beginner Smartsheet user and I have listed my set of requirement to track my schedule health task. The requirements are based off % Complete and % Time Elapsed. Requirements below: Tasks that show status of “Complete” - Blue Status in progress, where the % Complete is greater than or equal to Time elapsed. -…
formula date question
how do i represent this in a formula -date column i need it to input one or the other... earlier of April 30 or date in column 2 thanks
Calculating months formula
I am trying to calculate the number of months to date from a date column. Any suggestions?
Daily manpower
I am having trouble creating a consistent formula to track how many workers will be on site for a given day. Based on the start, end time, and count of manpower for each task, I have used that as a reference for a SUMIFS() formula in a separate column. I have also added a date column that shows a list in ascending order of…
Using NOT HAS with AND in formula
I am trying to capture work done that was assigned to individuals in three different scenarios: Scenario 1) work done by members of a specific team (team members listed on a different sheet, noted as {ID Team Roll Call Sheet Range 1}) Scenario 2) work done by people that are NOT members of this specific ID Team Scenario 3)…
Help with COUNTIF formula for between statement.
I am trying to show a count for how many values fall between >=100 and <150. But it is counting those in the column that fall into both categories duplicating the number. Here is my current formula: =COUNTIFS({SMARTRECRUITER, DEG Range 1}, <150, {SMARTRECRUITER, DEG Range 1}, <=100) Then the next row would be:…
How do you link certain information from a form to a sheet or report?
I am trying to link certain information from a form to another sheet. The form is a questionnaire with a Likert scale from 1-5. If the user select a 1 or 2, they are required to put in a comment. The comment is another question which shows as a column on the sheet. And lastly, the user who is filling out the form will…
Data Migration/ Data Shuttle between 2 sheets
I have 2 sheets Sheet 1: Projects pending approval Sheet 2: All the projects that have been approved I want to build functionality where when I check an approved box in Sheet 1, it will automatically push to Sheet 2. There are a couple issues/ complexities. One of the biggest issue is that the Sheets have different column…
Adding networkdays to a date to get a future date
Hi. I have a Finish date in my programme and I have a given Networkdays number. When I add the Networkdays to the Finish date in order to return to a new Finish Date, the formula returns #INCORRECT ARGUMENT error. Please help.
Manual % complete formula in the parent row
I am not using % complete automation in the parent row as some sub tasks do not have dates. However, using =AVG(CHILDREN()) in the parent row I get an incorrect % complete. The actual %complete should be 26%. Do I need to use a different formula allowing for task duration?
Help Article Resources
Trending in Formulas and Functions
Need to find all instances of value and return any non-blank cell from another sheet?
Hello Everyone, I'm stumped and need some assistance. What I am trying to do is look for the value in the Cable Number column (Cable Number]@row) on the master sheet in the Cable Number Column on the Update Tracker (Update Tracker Cable}). There will be multiple times this value is in this column but some dates will be…
Hello I am trying to create a formula that returns a specific date when a dropdown selection is made
class requested start date Jan 13, 2025 - July 14, 2025 Oconomowoc, WI Jan 13, 2025 - July 11, 2025 Huntsville, AL (new site) Feb 10, 2025 - Aug 11, 2025 Amsterdam, NY Mar 24, 2025 - Sept 22, 2025 Fontana, CA Apr 21, 2025 - Oct 20, 2025 Oconomowoc, WI May 13, 2025 - Nov 17, 2025 Huntsville, AL Jun 16, 2025 - Dec 15, 2025…
How Do I add Sum(Children) at the bottom of the children rows
Hi, How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom. I usually create a parent row, then add rows beneath it, indent them and add the formula =Sum(Children) to the parent row to calculate the total. However, that structure was confusing for users, and they…