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
adding less than variable
Hello, I have the following formula: =SUM((Length@row * Width@row) / 144 * 150) I would like to add a variable that gives a result of $491 for an result that is less than $491 but answers the above equation for any sum that is greater than $491 ie: example 1. 24*12/144*150 = $300-- I'd like the answer to populate as $491…
How can I total actual hours complete by who it is assigned to?
I currently am able to calculate the total hours assigned to each person, but I would like to show how many hours are complete and that still need to be completed for each individual. This is the formula I am using to calculate total hours assigned and this is working. =SUMIF({Assigned To 3}, Primary24, {Estimated Hours…
WBS with additional naming
Hello! I'm using the Work Breakdown Structure - Column Formula Configuration template (https://community.smartsheet.com/discussion/77827/work-breakdown-structure-wbs-column-formula-configuration/p1). I am wondering if it can further be customized so the WBS. The current configuration is 1 1.1, 1.2, 2, 2.1, etc. I'd like to…
Is there a way to add a due date with multiple criteria?
I am trying to set up my sheet for the child rows to say: If QC Frequency is Daily then Due Date is every business day of the month of the parent row If QC Frequency is Weekly then Due Date is every Friday of the month of the parent row If QC Frequency is Monthly then Due Date is 3 business days prior to month end of the…
Using Index/Match to pull in data
Hello. I am trying to set up Index/Match to pull in Data from another sheet. I eventually would like to pull the same columns from 3-4 different sheets to combine them into a sort of "master sheet" for these values that I can run reports on. Here is the sheet with the data, And here is the "master" sheet I am trying to set…
Add new record to one sheet from another
Greetings, Our QA team has 2 Sheets that they work from: QA Tracker - Tracks Call Evaluations QA Rewards - Tracks rewards for any employee with a 13 or 14 score (Exceeds Expectations) Right now they have to enter data into both sheets for the evaluations that are a 13 or 14. We were looking to automate adding these records…
I am not able to change a date in my plan. Is it a glitch? as it works fine usually.
I have created a project and later I need to modify the dates, but it is not allowing me to do so. I think it is a glitch.
Lookup multiple values from a dropdown cell and SUM
Hello, I am trying to populate Total Points from Sheet 1 with a formula. I would need to do a multi-value vlookup for my Sheet1[Color] and grab the related points from Sheet2[Color] and SUM them into my Sheet1[Total Points]. Is there a way to do this in Smartsheet? Please see attached images Thanks in advance
Help with CountIf
Hello, Trying to do this, but not sure how to write it in Smartsheet. I am trying to count a Multi-dropdown field only when the employee field is a value I have in my metrics. So I can do this, when I only want to count some of the application Assistance. =COUNTIFS({Staff Member Count}, Employee@row, {Non-Billable Services…
How to link an entire column to another sheet
I need help. I want to link an entire column to another sheet so I do not have to manually link them all the time. Any suggestion? Both columns are labeled the same on each sheet. I tried the VLOOKUP and index, and they haven't worked.
Help Article Resources
Trending in Formulas and Functions
Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
Counting items in a cell separated by comma
Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community. Thank you again!
Need a formula for % complete for all phases on the parent project summary row. Row is non editable
I need an average formula in the parent project summary (row 23). Formula should include all phases (initiating, planning, executing, closing). The parent row is un-editable and not allowing me to enter a formula.