Hi, what is the best formula to collect a text in a range of column and return it into main column?

Christian_Clark23

Christian_Clark23 ✭

01/10/24 in Formulas and Functions

Tags:

0 ·

Answers

Paul Newcome Community Champion

01/10/24

Are you able to provide more details? What columns would be referenced and where would you be pulling them to?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

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?