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.
Hello, In my source sheet I have a multiselect column called "Problem Code to be Updated". I am trying to use the reference sheet in the screenshot to identify if the multiselect cell in the source sheet has any of the problem codes where the "Technician Assigned Problem Code" is "Yes". The dropdown values are all taken…
Hello I know this might be very simple but I have tried everything to cross post a value from one sheet to another and I always get the wrong ref error or the unparseable one, this is the formula I'm trying to use, please help. =COUNTIFS({RE Projects Range1}, "Counter", {RE Projects Range2}, "Complete")
I’m looking for a cross-sheet formula in Smartsheet to calculate the average Turn Around Time (TAT) by specific Site Numbers. Source sheet details: Site Number (text/number) Turn Around Time (number; measured in days) Target sheet details: I have a row per site and want a formula in the Avg TAT column that returns the…
