-
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…
-
Basic NETDAYS Help!
Disclaimer: I'm a SmartSheet beginner, and only at an amateur level with Excel formulas. I've reviewed quite a few NETDAYS posts on here already and tried variations of the solutions in all, but so far every NETDAYS variation I've tried has returned the #UNPARSEABLE error. I'm trying to write a formula that will calculate…
-
INDEX(MATCH) or JOIN(COLLECT)?
When we first started using Smartsheet, the rep who handled our "Launch Package" created the following formula. =IFERROR(IFERROR(INDEX({SupplierItemNumber-AL}, MATCH($[Our Part Number]@row, {OurPN-AL}, 0)), INDEX({SupplierItemNumber-MZ}, MATCH($[Our Part Number]@row, {OurPN-MZ}, 0))), "ERROR - CHECK PART#") It searches two…
-
Calculate Total % Complete Checked Boxes of all Parent and Child Tasks
Project: I have a massive checklist we use for event planning (700+ rows!) and want to be able to know how far along in the planning we are percentage wise for one particular event. Goal: I want the Parent row %s to be the total percentage complete of all their Children tasks. The parent row is setup as an event planning…
