-
Rolling 12 month - need to mark line items in a sheet if they fall in the last 12 months
I have a detail sheet where we gather data as projects are closed. We want to be able to have reports and dashboards for the current year as well as the last 12 months. I have current year figured out without any issues, but I am struggling with how to filter for a Rolling 12 month period. I have created a Metrics Sheet to…
-
Formula to count the overdue task with Assigned Person
To brief, need a formula to know the overdue count for each assigned persons. With these details, will help show a chart in dashboard
-
Formula
I'm hoping someone can help me out here. I'm looking for a formula to calculate how many items have been sold but have not been shipped. Example: I want it to add the #s in the Color column of all lines where WH Location = 8A-8Z unless "Shipped" is in the Vendor column.
-
Highlight/Calculate Equipment use clashes in a project plan
Hello Community! In the following Project Plan (example), I want to use a column formula or conditional formatting to highlight/calculate when a specific equipment that is used for a task (column named Equipment - currently set to text) is already booked for other tasks/projects at the same period. Ideally, to also return…
-
COUNTIF Checkbox is NOT checked in a cell under a parent row
Hello! I am new to Smartsheet and am having a hard time with a formula for counting in the cell [Action Plan Progress]25 if a checkbox with the parent row 34 under sub row 37 (Checkbox38 to Checkbox41) is NOT checked. I keep getting #UNPARSEABLE Is there a better way or is COUNTIF the right way to go? Thanks!! -Whitney
-
I want to populate a Quote with information from a price list sheet
Hi Is there a formula or functionality that would enable me to to create a quotation using data from a price list on a separate sheet ? For instance on the price list sheet Column A ( SKU / Stock Code ) , Column B ( Description ) , Column C ( Unit Price ) . I want to fill the SKU / Stock code into the quote and have the…
-
Pulling information from second sheet based off one criteria and and if it falls between two numbers
I have one sheet that has job title, salary and then a column called Thirds location where I want to pull in information from another sheet and have it say lower third, middle third or upper third. On the other sheet I have the salary ranges and then broken into thirds. For example, For sally Gold, I want to reference the…
-
Count Days in Month across Years
I am looking to be able to count the dates in a month between a campaign start and end date that crosses years so that I can project the monthly spend amounts. I am close in that I created monthly columns and am using this formula to count the days within the flights in each month: IFERROR(IF(AND(MONTH([Flight Start]@row)…
-
What is the best way to copy Workspaces
Hi everyone, I am looking to create copies of some of my Workspaces and am facing 2 different issues. The 1st issue is I have a large interconnected Workspace with over 200 items inside it. I need an exact copy and don't want to relink everything as I would need to do this multiple times and would be days of work. The 2nd…
-
Current Week for Period
I'm trying to use a formula to identify the "Current Week" in my file. The file calculates the reporting period based on the date the new row is created. It also calculates the reporting week number based on the period ending date. The issue is that when I use the WEEKNUMB function to calculate the "Current Week" it does…