-
Formulas =SUMIF
Hi, I need help to solve this puzzle. I'm using this sumif formula =SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value}) to sum up the total value of invoices against a particular order number. I've checked that all columns are formatted as text. See snap shot of actual…
-
Full year calendar - accounting month/quarter end
Hi All! I am at a loss at how to even start this design. I have approximately 15 tasks that occur every month on the same BUSINESS day I have another 5 tasks that occur on the same business day every quarter. I would like to see this in a calendar view Any suggestions on how to build this? ie: Formula for the 'due date'…
-
Checkbox Formula
Hello! I am wondering if anyone can help me with a formula build. I have two sheets that have checkbox columns and unique codes. What I want to do is on one sheet, when all checkboxes are checked that have a unique code in the row to automatically check a checkbox with the same code on a different sheet. The accounting…
-
Is there a way to automatically add an entry on a monthly basis?
Hi, all. I have recurring expenses monthly and it would be cool if I could have a new entry appear every month. Is there a way to do this? Thanks!
-
How to Link my 2020 Capital Budget to my Capital Budget Form
Hello My organization has finalized our 2020 Capital Ex Budget. Starting in January 2020, I want to create a Capital Exp Form that provides the options that were approved for the 2020 Cap Ex Budget. For example, the form would be set up as follows: 1. Is the capital expenditure request a 2020 approved capital expenditure.…
-
Update triggered by day of month, repeat daily until complete
Sending a single update request does not always generate a response because many people are not good about answering all their emails, and then it gets lost in old email. I'd like to generate a daily update request that begins on a set day each month (like the 14th) and repeats daily until the person completes the update…
-
Dates in formula AVERAGEIF
Hello, I have problem with the dates in the formula below (in sheet summary) =AVERAGEIF([Date of request]:[Date of request], >07.01.2019, [Completed in days]:[Completed in days]) The Smartsheet returns me the value 0 that is wrong cause I have lots of numbers that meet this criterion. Please advise and thanks in advance
-
Formula Creation l Conditional Formatting (Automating the Process)
Hi! I am attempting to generate a formula to mimic the one I created using conditional formatting (essentially, I would like to automate the conditional formatting trigger). Here's how I would like the sheet to work. Based on the "Risk Classification" drop down selected, I would like the sheet to pre-fill the "Periodic…
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
Workflow or Alarm
Hello all, I work in company established in Germany. So my english writing can confuse you. I am new here and want to ask a question regarding the workflow / alarm tool. The automated mails are linked to a formular or the receiver gets a link to the complete Project. Is it possible to link the alarm to a DashBoard? This is…