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
How do I automate an inform email without sharing the sheet that collects the data?
I am creating a audit to collect data. I want to share the results of the audit via email, it is notifying me that I need to give them access to the sheets. This would have others data and would not want everyone seeing.
Sheet Summary
I want to take a field on my sheet and compare it to the total submissions on another sheet to get a percentage. Ex. I want to take the total for cell/number of total submissions (rolling) on another sheet so that it updates automatically each time someone submits the form. How would I do that formula?
Automatic RYGB Lights
Hi All, Currently I'm trying to make my RYGB column give the right color light when it meets certain criteria. This must be based on a Start Date column, End Date column and a status column, but I can't seem to figure out a formula that works. So the way it should work is like below: Is there anyone who might know a…
IF Formula questions
Apologies in advance, this is a real newbie questions. I am trying to create an IF formula which checks if the value of column Chargeable is TRUE it should then divide the value in Quantity cell by 7 and store in the formula cell. If Chargeable != true then set the value in the formula cell to zero. Following is what I…
I want to have a cell incrementally increase by 1 each time a checkbox is selected in another cell
There are two columns named Column4(Column type - text/number) CHOOSE(Column type - Checkbox) Whenever Checkbox for reason A is checked I want Column4 to increase by 1. (Ex: If checkbox "A" is checked 3 times I want Column 4 adjacent to it show "3") Likewise for all 8 reasons.
Alphanumeric column add 1
Hi All, Anyone know how to add 1 in the alphanumeric column? For example: ABC-001 ABC-002 ABC-003 Excel formula is =LEFT($E$2,4)&TEXT(RIGHT(E7,3) + 1,"000"). Anyone know what's the formula in Smartsheet?
Updating the Red or Green Status Column based on Dates from another column
I'm trying to create a formula that changes my status column to the red or green symbols. I want to base it on my Renewal Date column. I looked at some examples on the site, but wasn't able to get it to work on my sheet. I was trying to set up a formula around the following parameters.. If date is in the past turn status…
Consolidate entries from multiple columns and add a hard return (or extra line) between entries
I would like to use a helper column to add a space and division between entries in multiple columns in the same row - i.e Row is a deliverable Column A, B and C are the status from 3 teams that have a status on that deliverable consolidate the status in Column A, B and C into a single column/cell AND divide out the status…
How can I find a position of a character in a string?
Hi all - I'm trying to find a position of a character within a string, which in theory seems simple - just use the FIND() function. What I'm struggling with is when there are multiple instances of the value, and I want to start at the 4th instance (for an example) of it. Here's an example of the String I'm trying to parse:…
Nested IF statement
Receiving an error with the formula and couldn't find anything similar within the existing posts. I have 3 columns (Testers) and each tester will have the option to choose if something passed, failed or is ready to retest. I'm trying to have the formula ready If Column A reads Passed, then read column B and if that read…
Help Article Resources
Trending in Formulas and Functions