Formulas and Functions
Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.
Discussion List
-
Announcing Several Formula Enhancements Available NowIn Formulas and FunctionsHi Community, One of my favorite things about Smartsheet is our powerful formula engine. We’ve been hard at work making several improvements that will not only make building formulas easier and faster, but can help you reclaim time throug…
-
Copy parent row onlyIn Formulas and FunctionsI have automation set up to copy rows marked as "key deliverables" in my project schedule into a separate, key deliverables status tracking log. Unfortunately, when a key deliverables row in the schedule is a parent row -- i.e., …
-
Symbols Color Change based on DatesIn Formulas and FunctionsHello, I'm looking for a formula that will automatically change based on close we are to the due date. So let's say the following: 30 days till the live date, Green 15 days till the live date, Blue 5 days till the live date, Yellow under…
-
Sales Projections SheetIn Formulas and FunctionsHello All: I'm working on a sales projections sheet and looking to create and easy to notice symbol, on target, below target, and off-target. What is the formula to be able to easily create this? Thanks in advance. MH
-
How to deconcatinateIn Formulas and FunctionsI need to be able to separate out the five sections separated by commas into five adjacent blank columns ED Class, Wednesday, 01/20/21, 9:00 am - 12:30 pm, Happy Hospital Thanks, Laura
-
Cross-sheet COUNTIFS with three parameters.In Formulas and FunctionsInside a current sheet I can do a COUNTIFS with 3 parameters. I do not seem to be able to do that if I am referencing another sheet. It appears the limit is 2. Is this correct or am I missing something?
-
How to convert a number with a fraction reading as text, to a number (3 2/3) to 3.66In Formulas and FunctionsI'm having an issue with incoming data being read as a text. I need it changed to read as a number so I can incorporate formulas. I've tried a few value formulas. The initial formula to pull the numbers from the original text is substitute…
-
Automatic Workflow for multiple rowsIn Formulas and FunctionsHi there , I would like to learn that , when we crreate an automatic workflow system taking action based on one row , i want that at the same time system will take action for all the rows with one alert. For example imagine that , there ar…
-
Need help with syntax for IF(AND(OR nested statements for a risk assessment tableIn Formulas and Functionsthis is what I have, getting an unparseable error. I changed all the "" to straight quotes. trying to make the cell this formula is in, equal a risk rating as determined by the formula, the graphic matrix is below. HELP!! =IF(…
-
formula that when completed next start date is +330 daysIn Formulas and FunctionsI am trying to figure a formula that when I actually complete something, that the start date row will trigger the next time it needs to be done. Example: I have start date, due date, and actual complete date. Start date would be 2/1/21, wi…
-
Using Smartsheet for Knowledge ManagementIn Formulas and FunctionsDoes anyone use Smartsheet for Knowledge Management? I'm thinking of utilizing Smartsheet for this purpose ("How To" videos, templates for employees to use, ect). I was wondering if anyone uses if for a similar purpose if you cou…