-
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…
-
complex if/and/or question
I have 5 status columns, each with 4 possible values (Approved, Approved with Comments, N/A, Resend). I want to fill in an "Overall" Status The 5 columns are __________________ Tagless Status Front Graphic Status Back Graphic Status Right Sleeve Status Left Sleeve Status Other Status My logic is If all of the columns are…
-
Financial Year Saving Based on Implementation Date
Hi All, I have a sheet to track cost savings and would like the financial year savings to change based on the implementation date. The three fields are: Implementation Date - restricted date field. Savings Full Year - the overall savings throughout the full financial year, 01 July 2020 to 30 June 2021. Savings Financial…
-
I Need help with formula to prevent AVG Parent percentage from rolling up.
I have several (18 rows to be exact) rows that I am need to get the AVG percentage for. 17 of the rows are currently at 100% and 1 row is at at 92% (because there is one step still left to complete before it can be at 100%). When I do the formula AVG "Children", it wants to round up the percentage to 100% (the actual…