How to convert formula column per cell formula

Sespedido_23

Sespedido_23 ✭✭

08/02/24 in Formulas and Functions

I have different formulas per row on one column, how can I convert the different row formulas into one column without having the rest being deleted?

0 ·

Answers

heyjay ✭✭✭✭✭

08/02/24

Right click on the cell, select the last item on the menu context.

...
0 · Share on Facebook Share on Twitter
Sespedido_23 ✭✭

08/02/24

I don't seem to have that option when I right click. Only convert to column formula is available on my end.

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

Record a date automation isn't working
I set up the automation below, and it's not working. When I change the status of a row to complete, nothing happens. If I go into the automation manager and select "run" or "test" the completion date column fills in with today's date. What am I doing wrong? This should be straight-forward. I've tried building this…
Identifying oldest entry on sheet, for different groups
Hello! I am working on a "waitlist" process, where the sheet will have multiple candidates under each work location. I need a formula to identify the oldest entry for each location, and if there are multiple entries for the earliest date, use a "score" column identify the higher score as the next candidate in line. Example…
Week Over Week Change
I have a sheet that has orders entries from the last 6 months. This sheet continues to populate as more orders are made. This is just my repository sheet. I am looking to get the week over week change metrics for the last 7 days. Here's the formula that can provide me that week over week change: Week over week %% =…