Formulas and Functions

Archives for November 2020

Is there a way to automatically add two sheets data into one new sheets as parents and childrens row
Hi, I was wondering is there a way to bring two smartsheets data into one automatically. Smartsheet A datas will be the parent row in Smartsheet C, and Smartsheet B will match the smartsheet A data and automatically added into Smartsheet C as children row. I did a lot of research and it seems like it's not possible.
How can I only have an attachment sent via a workflow
At the moment I receive pay statement requests from staff. I have already created the workflow where if I make the attachment it will trigger the message. My problem is that it also sends the link to the page, and the recipients continue to request access to the sheet. I do not see any other options that do not include the…
How to use AND and OR in an IF function?
So the answer has to be Operator plus one of the other 3 "OR" options. IF [Operator or Engineer]@row = "Operator" AND either [Shift/Available]@row = "1-Grave" or [Shift/Available]@row = "3-Swing", or [On or Off Site]@row = "Off site" then check the box. =IF(AND(OR([Shift/Available]@row = "1-Grave", [Shift/Available]@row =…
Days Lapsed/Column Formula
How do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it states it's not quite right to convert. Any suggestions?
Splitting Text to Columns
Our campaign names are made up of a string of text values combined into one name, as follows: FY_sbu_pillar_marcom objective_campaign_sub campaign_consumer journey_brand_campaign tactic_weather triggered I am looking to split each value in this name into it's own column, which I know is something I'm able to do in Google…
Not sure what kind of formula to use
Hello, I am creating a project deconfliction sheet. I have a column where a date is manually entered. I would like to create a flag when any of the cells (so far 13) in a row that contain the same date will check the box. Thank you in advance for your assistance. Sharon C
What is the formula to count only if two checkboxes in separate columns are checked?
What is the formula to count only if two checkboxes in separate columns are checked? If one of the checkboxes are not checked, i do not want that line counted.
IF OR Statements not working correctly
I have a question on 'IF' 'OR' statements. I researched and created one that looks like it should work. I am trying to display a status field with 'Completed' or 'Cancelled' and I have the field to start with an auto-fill - from the form with 'In-Progress'. I tried making each statement in its own field to display…
How to update targeted completion dates with actual completion dates?
Hi there, I have tasks with targeted start and targeted finish dates, all with appropriate predecessors with or without lag, as well as durations. Is there a way for the targeted completion date to remain as a target until the actual completion date is entered? For example, someone signs a letter of intent 100 days after…
How to I count a total of hours based on if a checkbox is populated?
I would like to use a functionality of totaling a training duration based on if that course was selected. Ex: Session A is 1.25hrs, user checks the box for this class - I need to be able to sum up the total time based on all the populated checkboxes. any help would be greatly appreciated. thanks Judi

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

Concatenate formula to combine Date and Time into unique code
When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025-01-01 which is how I need it to appear in the result. How can get the Concatenate formula to just reproduce the Date format…
How to fix adding 1 or -1 to date difference calculations
Hello, I'm trying to set up a formula which will calculate the difference between two dates to achieve a days overdue number for our orders. Current formula is: =IF(Status@row = "Delivered", NETWORKDAYS([Delivery Date Expected]@row, [Delivered Date]@row)) This is returning an almost correct result, except it always adds a…
Calculating KM Distance between Lat and Long
Good morning. I have tried the 2 formula's that I found on the internet and copilot and neither are working for me. Can someone please help me figure out how to calculate the KM distance between the lat longs?

Formulas and Functions

Discussion List

Help Article Resources