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.

Is possible to show a modified date entry (created by a form) in a other sheet.
I have one shet, created by a form, witha a entdy date(modified date entry), i want to show this entry at my master sheet wher i colect all other entrys. that is what i try. =IF({SKU Warenaufnahme Range 1}, [Inventory Code (SKU)]@row, {Entry daty range 1})
Nested If, then, CountIf formula
Hello, I am trying to create a nested If, CountIf formula, wherein the formula refers to a column and only counts status if that column is = to 1 of the 4 options. Then, ideally divide the # returned by the total to return the status over all %. For example if Column: Address is equal to: ABC Street, then Count Status…
Combining CountIfs statement with Date
I have a CountIfs formula that I'm having trouble getting to work when I add a date condition into it. Basically I'm trying to get a MTD output based on several countifs as well as only counting if an adjecent cell does not contain "Appointment Allowcated". The formula works perfectly when I don't have the IFERROR…
Turn an online survey to a printed version
Hello, say I created a form (to serve as a survey). I can push this link out, no problem. What if I wanted to make a printed version of that survey, how would I go about doing that? The use case for this is when our customers come in our office and take training. At the end of their training, we'd like to be able to hand…
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 ?

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

Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags