Formulas and Functions

Archives for January 2022

Is it possible to use ISTEXT or ISNUMBER with a cell that is the result of a formula?
It appears not, but I'm wondering if there's a work around. I have a column with numbers that sometimes have letters at the end (in which case I need to address and possible remove them). Sometimes there are letters at the beginning of the number in the column, but those are needed so I can't use ISTEXT or ISNUMBER on the…
Sum of column by date
Hello- I am trying to build a formula that calculates the sum of a column every day. EX: 1/1/22-gives the sum of the column on that date 1/2/22, give the sum of the column on that date So we can see how the calculation changes day over day
SUMIFS & CONTAINS formula help
Hello! I am trying to total the # of points in a column if multiple criteria is met. One of the columns I need to check is a multiple select column. I've tried the following and it keeps coming back with 0 when the sum should be 2. =SUMIFS({Master Absorption Form Range 3}, {Master Absorption Form Range 6},…
Pulling from contact column value from source sheet to project sheet based on ID Match
I'd like to be able to pull the names from the contact column in Sheet A into Sheet B based on a match of the project ID in Sheet A and Sheet B so the names will correspond to the project IDs in Sheet B.
#divide by zero error with SUMIF
Hello, i was hoping someone can help me with this error. I'm simply trying to sumif a column with quarterly projections , some of which are still $0 as the projections haven't been enterd yet. And instead of the sum summing the 0 cells + the rest of the digits, it's just returning an error. How can I avoid this? Thanks a…
OSCAR TORRES
I am trying to count to amount of cells that have a date within the next 30 days, Any help will be highly appreciated
If cell contains value from another then populate with another Cell
Hi, Hoping someone can help with this scenario. 2 Sheets (A and B) If Cell 1 (sheet A) contains same value as Cell 1 (Sheet B), insert contents of Cell 2 (Sheet B) into Cell 2 (Sheet A). Thanks in advance.
Divide By Zero Error with Average
Hi, I'm trying to set up a formula that averages the scores for four columns, but doesn't bring up the Divide by Zero error if the scores haven't been entered yet (either leaves blank or puts a 0). The Average formula works fine but I can't get the IFERROR part to work. Current formula: =ROUND(AVG([LOR 1]1:[LOR 4]1), 1)…
Extracting part of text with a formula
This discussion was created from comments split from: Returning text using IF Function.
Need a formula to recalculate a deliverable at the end of each week
My project is that a certain number of Forms needs to be created within the next 11 weeks. We have a group of people working on the project and right now I have the weekly goal for form creation divided by the weeks left. I want the formula to recalculate the weekly goal for the subsequent week at the end of each current…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Getting Unparseable error using IF function
Hello, I am trying to use the IF formula to perform a date calculation based on a value selected in another column but keep getting UNPARSEABLE error. Here is the formula that I have used. I have also pasted the screenshot for reference. Can anyone help me out on this? =IF([SLA]@row = "Standard",[Feasibility_Start…
Attachments not sending in Email Alert
I've had a sheet set up where once the form is filled out an automation will create a PDF and then from there is will send out an email alert to the designated email box. The alert includes and documents that were uploaded during the form being filled out and the PDF that the Smartsheet creates. Its been doing this fine…
Automation to Send Notification to Shared Mailbox
I am trying to send a notification to a shared mailbox, when a row is added (from a form), with certain criteria within one of the fields on the row. Ideally this row would contain the information from the submission (similar to what is sent when submitter selects 'Send me a copy of my responses'). If this is possible,…

Formulas and Functions

Discussion List

Help Article Resources