-
Using IF to return a value from another cell
Hi All, Currently we have the below system in place to return the value of a specific cell out of a specific column. So for example, If the country is Germany it pulls the information out of the Germany Column. This works great! But now comes my problem. We have added a Germany Refurbishment Column. So now it should work…
-
Auto-hyper-link a sheet generated using template
Hi Smartsheet, I got a sheet with each project schedule sheet "hyper-linked", like below project A. If you click project A, a schedule sheet pops-up. I use data shuttle to generate all the data from other internal data. Then, using these data, we use a template to generate schedule. The sheet has index/match formula and…
-
Can't seem to get this simple formula right.
{Weighted Forecast} is USD amount column {ExpectedClose} is a date column This formula in row 8 shows "Invalid Data Type" For row 9, I am replacing {ExpectedClose} with {CreatedDate} and it works well. May I know what could be the error? {CreatedDate} in the source sheet is an Auto Date column {ExpectedClose} is manually…
-
help with sum if
I am hoping to sum up the amount in the P&I Amount Colum if the Status Colum is Confirmed or Needs Org Profile Updates, or Summited (under review), or etc. in the Total Approved cell row 43 and column P&I Amount. I think it is a sumif formula. The formula I currently have is =SUMIF(Status1:Status42, "Confirmed", [P&I…
-
Why am I unable to run a particular workflow on a weekly basis?
Is it because it's referring to a date field? There are sometimes as many as 20 changes in a day as renewals occur in batches so I'm trying to avoid getting an email for each row where the renewal date changes. Thanks!
-
Automation to "Change Cell Value" to embed a formula into the cell
Trying to set an automation to "Change Cell Value" 2 columns involved: "BARCODE" and "PACKAGE UID/LOT #" If "PACKAGE UID/LOT #" is not blank, then I don't want to override the data in the cell, however, in the absence of data in that cell ("PACKAGE UID/LOT #" is blank), then duplicate the data from "BARCODE" into "PACKAGE…
-
25m Outbound Links Limit
Hello Does anyone know if there is a way to see what is the current amount of outbound links in the sheet (with reference to the information I found elsewhere: "there is an outbound cell limit of 25-million. This includes cross-sheet references, in-sheet cell references, column references, and range references."? This…
-
Formula to replicate column values when certain value is matched
My source sheet has 3 columns such has Name, Location ID and Grade. When i provide the Location ID in the target sheet, i would require the Name and Grade values to be populated for that respective Location ID. -For ex: If Location ID 123 is entered in Target sheet only once, then all the Names and Grade which has same…
-
Number of Days on hold from date entered and current date
I am new here, please be kind. I am trying to add the correct formula in my 'Days On Hold' column. To calculate how many days something has been on hold from the 'Date Entered'
-
Adding in a cell via if then?
Hello Community, I need help with a formula. I would like to add the totals into one cell based on the following condition but don't know how to write the formula. For example, if the Status column, has any of the following results, then add the amount in the "Amount" column in this cell. Any help would be appreciated.