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.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Formula based on timelines (start and end dates)
I'm trying to basically show sr. mgnt how many high project projects are all happening at the same time -- ideally I'd like to count them -- is there an easy way to do that? Essentially I'm using project type = High then want to show those start and end dates that fall w/in maybe a quarter range. Is that possible? TIA!
Using COUNTIF children to change a Status with multi criteria
Hello! In our Timing and Action we have a formula that indicates the status of a Parent row based off the cumulative Status choices (Not Started, In Progress, Complete, N/A) of the Children Rows below it. How do I get the formula to register the Parent Row 'Complete" when the CHILDREN Rows = both Complete and N/A I want to…
Getting countif to work between sheets
I can not get the countif function to work between 2 separate sheets. One of the sheets is my metrics for the pipeline. I want to get a count of how many times a name(account holder) is used on the pipeline and I keep getting the error unparseable or incorrect argument. I try linking the sheets and get the same errors. I…
#INVALID DATA TYPE error in formula
Hello. I have a formula which work fine for 2 out of 3 variables, but not the last and I cannot figure out what is wrong. Use case: I want the Waiver Approval Status column to read two approval process columns and return Declined if either row shows 'declined', 'pending' if either row shows 'submitted' and 'approved' if…
Utilizing query strings, formulas, and webforms to have a weekly training tracker
Objective: Have a dynamic form autosent and already filled out (mostly) on a weekly basis for a large rolling number of teamembers, while all being managed by the lowest tech savvy group in my organization. In order to complete this I have 3 sheets. training files database. The date field is filled out as far as 2100 and…
Triggered > Move error
Row's cant be added to the destination sheet because the primary column has the same name as a non-primary column on the source sheet. < How to fix this ?
Automate (100%) in % Completes column based on date entered in Complete Date column
HAPPY FRIDAY EVERYONE All, I need some help with this formula The goal: when a Complete Date is entered the % Complete Column will update to 100% The results have been unfavorable =ISDATE([Complete Date]45),([% Complete])="100%") This one gives an unparsable =IF(ISDATE([% Completes]45), "100%") This one doesn't give an…
Auto Populating Formulas
Hi everyone, I have a simple sheet that has data inputted into it from a form. I have the form inputting the new data at the top of the sheet. I have read the following page many times:…
Can I change case AFTER the cell is referenced?
Hello, I have a Master sheet with hospital unit names. Some of the names are all caps, and I wanted to change that to be first letter in caps only. The words themselves would be the same. Only the case would change from capital letters to normal letters. The cells where these unit names are are referenced in formulas. Will…
RAG Range Formula?
Hi I have a RAG legend which looks like this-: 0-49% = Red 50-79% = Amber 80-100% = Green Like below I have a formula on my sheet which calculates a percentage on a monthly basis. I want the percentage to show in the next cell the relevant RAG e.g. 82% would be green or 55% would be amber. What is the best functions to use…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags