-
Sum column if another column is not blank
Hello all, I am trying to create a formula that will only sum budget cells that have a date in another column, if the date column is blank then those budgets would be excluded from the total sum. I'm having a hard time finding any formula that will work, possibly because these cells are linked from another sheet? Any help…
-
Why does my Metrics constantly stop calculating correctly?
I've been making a "Metrics" sheet for some time now, and in the beginning everything was calculating fine. But it seems to be when I add more "data tables" if you will, or more metrics, some tables stop calculating correctly. Here is what my sheet looks like for a better understanding So, the first few-ish sections will…
-
IFERROR LOOK UP
Hi All For our timesheets we use IFERROR to check another sheet against a job number, I now need this to check over multiple sheets not just 1 how can I do this please? The current formula is below. =IFERROR(INDEX(COLLECT({PMYS Job Tracker - Boat}, {PMYS Job Tracker - WIP}, WIP@row, {PMYS Job Tracker - Line}, Line@row),…
-
Calculate amount of days untill deadline and how many days is overdue
Hi Hoping you guys can help! I'm trying to calculate the days between a desired deadline and today (so kind of a countdown) and in the same field then also count if the task is overdue and by how many days. so, I was thinking, if it was counting down the days, it would be a positive number and when/if a task is overdue the…
-
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…
