Formulas
Discussion List
- I am trying to count (COUNTIFS) during a given fiscal year. My fiscal year runs from the month of July - June, so currently I am in fiscal year 2024-2025. Column Fiscal Year = Dropdown Column Activity…
- Hi Guys Please note the formula. see pic1 I am trying to count BS Numbers excluding zeros and blanks Pic1 However it's not returning the correct count, for some reason the formula is not counting some…
- I have a simple automation that looks at an employee sheet. On the 1st day of each month at 10am Central a report is sent to my email that SHOULD show the current months work anniversaries. However, e…
- I have created a Dashboard where I’m using the chart widget, the data is being pulled from a sheet (sheet 2), were I pull data from a different sheet using formulas (sheet 1) to be used on the Dashboa…
- My company is looking to replace an Excel spreadsheet that we use to record the results of an order report in SAP. The problem we have is that SAP populates each order by the lines on that order. So f…
- I need help in figuring out a more complex formula. Below is a screenshot of my sheet. What I'm hoping to devise is a formula to go into the yellow highlighted cells (a unique formula for each column,…
- Hello! I have a [DATE SUBMITTED] column and need to create a reference column that returns the fiscal year that date falls in. Something like this - =IF [DATE SUBMITTED] > 10/01/17 AND [DATE SUBMITTED…
- Is there a way to add sheet summary fields in a notification? It is possible to add cells by using {{Field}} but this doesn't work for the summary fields. Any inputs are much appreciated.
- We track data for customer accounts in a couple of different categories. This inevitably means that some customers (not all) appear in both data sets. We spend some time ensuring that the data entered…
- I have two sheets with a few hundred rows filled with site information. The common data between each table is the site number. What formula would I use in a cell if I wanted my primary smartsheet to c…