Sign in to join the conversation:
Hi;
I want to write the last cell in the row to the first cell. There are empty cells in between. Can you help me.
Good work.
Hi Ercument,
Not sure to understand correctly your requirement but let suppose you have Column1 to Column5 . If you want to get the value of Column5 into Column1, simply enter this formula in Column1"=[Column5]@row". Tell me if this is what you expected.
Hope this helps!
Have a good day,
Mathieu | info@evolytion.com
When data is written to any cell in the row I want to make, I always want to print the data in the last row to the first row.
Have a nice day.
As follows
Will it always be numbers and will they always go in ascending order from left to right?
There will not always be a number. There are project numbers, but there are letters in it. It will always go from left to right, but it will be in empty cells in between.
Ok. I am going to suggest a "helper row" in my example I will use row 1. In this row you will enter the numbers starting at 1 from left to right across the columns you want to pull from.
Then you could use a formula such as...
=INDEX([First Column]@row:[Last Column]@row, 1, MAX(COLLECT([First Column]$1:[Last Column]$1, [First Column]@row:[Last Column]@row, @cell <> "")))
The screenshot below shows the helper row on row 1 highlighted in green.
hi team for not getting quick response copy form smartsheet what are the reasons
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
Just wondering if anyone else experiencing this issue? The checkbox cells would normally be an empty checkbox but update the recent mobile app update, they would disappear on any column with checkbox type, specifically on sheets and reports, dynamic views is good. This is only happening on mobile app, browser works fine.
