-
INDEX MATCH Formula with Cross Sheet References
Hello, I am trying to write an INDEX MATCH formula that will return a due date on my metric sheet while referencing a much larger projects sheet. Currently, my metric sheet has two columns: "Project Description" and "Initial Documentation / Broad Scope Due Date" Both of my project descriptions are identical - one is a cell…
-
How to Use Certain Contact Cells in a Column and Combine into One Cell
Hello, I have a project timeline/schedule where I want to take each 'different contact', in a column and combine them into a single cell so I can create a notification to the project team based on different tasks that change to 100% complete. My team uses a template for the timelines and I would like to set it up so we…
-
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…
