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.

cross sheet countif formula
Trying to find the right formula to count a name column in one sheet based on a specific location in another column. I've done this successfully with numbers using sumif, but the count isn't working. Is it not possible? i tried countif and countifs....keep getting errors.
Batch rename hyperlinks
Hi I have a column with a long URL http://blblblblbl... There are about 300 rows in the sheet. I'd like to change the display text of the links to Preview for all of them. Is there a way? I can not do this one by one. (multiple sheets with the same set up). Thanks
If then statement for a list of individuals
Good day! I am trying to reference one cell in my spreadsheet that has a drop down list of 30+ people in the list. I want to create another cell using the if then formula to say if person a, person, c, and person h are in the first cell, provide this name for their manager. I have 4 managers that I need to divide this…
Uncheck the previous checkbox when a new box is checked
Hello How do I get rid of a previous check when a new checkbox is selected? This is what really need to happen: (Task Name 6 needs to transition from one to another (Idea, Concept, Design, Validation, Lanuch) as the approvals are sent out. When project starts it is automatically in the Idea Phase When Idea Phase Gate…
How to add few texts/words on countif(s) formula
Hi, can someone help me on the correct formula that I should use? I wanted to get the number of projects based on their status however the countif formula that I am trying to use doesn't work in Smarsheet but works in Excel. Below is the formula I used in Excel that worked: =COUNTIFS(B3:B11,"*contract…
Vlookup
I am updating information on to a sheet when I contact our customers AP dept either by email or Phone. The info I update includes Invoice- date- AP response. I want to use this data to link to another sheet that I am using to track open invoices via Vlookup. When I populate the sheet I have been inserting rows on top so…
RYG formula in response to a numbered cell
I am having a bit of trouble figuring out how to write a formula to automate RYG symbols. Basically I want the rules to be as follows: 1. If value is less than 4, RED 2. If value is greater than 4 but less than 6, YELLOW 3. If value is greater than 6, GREEN So far I have figured out how to do a single formula for 1 & 3…
Moving Rows with a Formula
Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
Is there a way to NOT auto number the 1st Row? ...and other SUM row questions.
I am using the first row for totals and it is throwing my auto numbering system off. Is there a way to have the auto number start on row 2? Alternatively, if I put my totals on the last row, the web form will populate new rows below my totals. What are some best practices to display my column totals on a continuously…
Issues with the new cross sheet formulas?
My totals were working finally on a summary sheet but then all the columns started changing to the same formula. I tried twice to go in and reset the reference sheet range but then it would just everything on the sheet. Anyone else have this issue?

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