-
Would Like to Copy a value from one location to another weekly
Hello! I have 2 sheets SHEETA and SHEETB. SHEETA has a ton of data in it and I want to take a value from one cell inside or the sheet summary it and copy it weekly to another sheet. I know I can copy rows but that is not an option for me. Is there another method I could utilize to automate this?
-
Information from multiple columns into one
I have a sheet that includes department and sub-department data, which is collected from a form. The sub departments all populate into different columns, so i have sub department columns (A, B, C, and D). For each row, there is only information in ONE of those columns because people only have one subdept. I want to create…
-
Formulas based off dollar amounts
Looking for a formula that says if column a has a dollar amount that is greater than $3000.00, display 1, if column b has a dollar amount that is greater than $3000.00, display 2.
-
Row number
Hi Thrill Seekers, I am seeking a way to access the row number of a row in a sheet. I would be very happy if this came in the form of a SmartSheet function (let's call it Row) so that I could create formulas like "=Row()" for the current row number or "=Row()+2" for the number of the row two rows below the current row.…
-
Progress Status / Health Automation
Good morning everyone, I'm new to Smartsheets and have been really enjoying the functionalities and automations. I'm trying to set up an automated Health / Progress status and keep getting a "#UNPARSEABLE" error. I've looked through my code and can't figure it out.... Can someone take a look and help me see what I'm…
-
COMPLEX INDEX/MATCH arguments issue: Project Updates Tasklist
@Paul Newcome @Paul Newcome I need your expertise My manager has tasked me with referencing data from a hierarchy of rows, for multiple columns, but wanting the Parent Row to be updated from the inputs of the data in the CHILDREN rows, which he then is asking for the most recent update of that selected customer. I am…
-
COUNTIF formula
I'm trying to figure out a formula to count the amount in the Budget column cell if the Actuals column cell is blank. Thoughts?
-
IF/ OR
Hello, I am trying to create a formula that encompasses multiple dates. The current formula I have is as follows: =IF($[In Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type In]5, IF($[Out Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type Out]5, IF(AND($[In Date]5 < ($[In Date]$4 + [03-OCT]$4), $[Out Date]5 > ($[In Date]$4 +…
-
Moving DATA from source sheet into new sheet that has formulas that need to be applied to new data
Hi, I have developed a new sheet (NEW PROJECT SCHEDULE) for our PM's to use that has a lot of formulas in it, on almost every row (Parent and Child rows) as well as Summary formulas for a Dashboard. This prototype has tested and worked well for new Projects because the original data is being copied to the NEW PROJECT…
-
Index and Match for multiselect column?
Hi all, I'm a little stumped on this one. I am trying to extract the selection(s) people are noting in a multi-select column in another sheet. I set up a marker in both sheets to I can use that as the indicator on where I can line up the Match formula but I get a #INVALID DATA error. Is there something simple I'm missing?…