-
Cross Referencing Sheets
Hi, We want to create a sheet that cross references another sheet and only pulls in data relevant to the partner with whom we are sharing the sheet. The reason we do not want to use a report for this use case is that you cannot hide the comments from a report and we do not want them to see the row comments. Please advise…
-
VLOOKUP for numerical values
Hi All, I am using VLOOKUP to retrieve numerical values from another sheet, the formula works, however when I have '0' in a cell, it pulls '1' also, which is the true value of the VLOOKUP. When I use the same logic with excel it works w/o any issues & brings the '0' value. What should I fix to get the same results? Thanks…
-
Flag formula?
Trying to use flag column...if date is within 3 days = flag, if not, or blank = no action. Below is the formula that is not working. What am I doing wrong? =IF (ISBLANK([Submit by]@row)), 0, =IF([Submit by]@row <= TODAY(+3)), 1 Thanks!
-
Deposit summary report vs. bank statements
Hi, We're trying to create the following project. I would appreciate getting some input on how to program it correctly. As a healthcare billing company, we post all account receivables to the patient's ledger. At the end of the month, we need to tie out the deposits posted to the bank statements to confirm that every bank…
-
Formula Quesiton
I have 2 columns - one Engagement and one Desired Engagement - If the two columns are not equal, I want the cell color to be yellow as an indicator. If the two columns are equal then, do nothing. How can write that formula in smartsheets ( since I haven't figured out a way to do it with conditional formatting)?…
-
Automatically update Start and Finish dates with new week
Hi, Does anyone know if it is possible to automatically update Start and Finish dates to the new week once it hits Monday? For example, I think the formula should somehow state "When the date changes to XXX (Every Monday), change Start and Finish to Today and Today (+5)" Not sure if this is even possible? It would save my…
-
Patti P
Good morning, I would like see if you could help me with a formula…. Below is what I have and it works, but I want it to return 0 if the [PO Qty] / [Work Order Qty] are empty cells… I have tried everything I can think of….. SUMIFS, IFERROR, ISBLANK…etc…. =SUM([PO Qty]@row / [Work Order Qty]@row * 1.0) Any suggestions?
-
Does this community have a bank of shared formulas, because this might be helpful to someone
This formula is very straightforward but it took more than an hour to build, so maybe I can save you some time! This formula looks at the field "Dash Help Due Date" and returns one of five things: No Date if blank This item was due x days ago This item was due yesterday This item is due today This item is due tomorrow This…
-
Formula - IF/OR
Hello, I am attempting to take the SUM of one cell and divide it by a range of other cells to get a percentage output. However, when creating the formula I am receiving an "#Incorrect Argument" error. I need the range in the column(s) because the column "Region Name" will fluctuate with the entries that are made from the…
-
Formula to pull through names of all projects relating to a programme
Hi I'm looking for a formula that will reference a sheet that holds programme and project names. I want to pull through all projects related to a particular project. How can I best do this? I did put it in a report but, on my Dashboard it means I can't pull the data through on my metric widget. I don't want it to show on…