-
Cross-sheets sweep check
Hi, I'm trying to cross check if a any of the values (text) from Sheet B 'Value list' column is contained in the row (text string) under analysis in Sheet A 'Description', if found, I want to retrieve the corresponding row vale from Sheet B "Class" column and bring it to Sheet A 'Class' column. I can't figure out the best…
-
How to use automation to copy only certain rows to another sheet?
I have large rows of dataset in a sheet. I am looking for a solution that can copy specific rows to another sheet based on certain criteria. I used the automation template for copying rows, however, on fulfilling the condition specified, the automation all rows in the primary sheet to the secondary sheet. Is there a way I…
-
Storing historical Data
Hi Folks, I have a number column that is updated monthly and is overwritten with new values. However, I need some calculations based on previous data and current data in that column. For example - I want to calculate the deviation from the previous count to the new count. How is this achievable? Does Smartsheet have a…
-
Automation: 'Copy Rows to Another Sheet' doesn't really work as advertised.
I have a project plan with a "Weekly Update" column for people to use when appropriate on a task-by-task basis. I want those updates to be saved in another sheet (the reason is that after updates are copied over, I will run another workflow to clear the contents of those cells so that they can be used again for another…
-
A = SUM(A,B) - possible?
Hi Looking to create an automation that creates a cumulative total. E.g. if "time entry" field changed then ADD "time entry" to "Total Time". Clear "time entry" Is this possible?
-
Symbol Formula to create a numeric value
Hello, I am trying to find a formula (if it exists) to add a numeric value to a Red, Green, Yellow symbol. I am assuming that I will have to add a column next to the symbol column and do an "IF" formula? Example of what I think I need: IF cell A equals green symbol, then cell B is 100 Help, is there a formula? Thanks, Kerie
-
Subtracting data from more then 2 columns
Hello, I have been trying to subtract numerical data from three different columns, and I have tried =[Submitted HRs]@row-[Lunch Time]@row-[Contracted HRs]@row and get invalid operation I tried using parathesis =([Submitted HRs]@row - [Lunch Time]@row) - [Contracted HRs]@row and get an invalid operation I have also tried…
-
change status based on previous row
Is there a way to have a formula change the status column when the row above it changes. For example when the status in Row 1, changes to "Complete" the status in row 2 will change to "Ready to Start" I know I can't put a formula in the drop down so I imagine some sort of helper column would be needed. or could this be…
-
How can I convert date to text?
Hi, I'm setting up data shuttle where unique identifier can be in multiple dates and would need to make sure all data in multiple days flow. In excel, I have a helper column as =ID&"_"&TEXT(Date, "yyyymmdd") to set as an unique identifier. From the Smartsheet that has a date of 7/23/24, how can I convert this into…
-
Calculation Sheet formula needed
I have an existing Calculation sheet that pulls "linked" information from pivots. I want to simplify and replace with formulas instead from a couple different sheets. (1st Sheet Name: "Migration Grid 03.29.23") Columns In Reference - Key below: "Stars Team" = "MS", IV, etc. "Ident $" = dollars "IMP $" = dollars "Valid $" =…