-
Return the most recent result that is not blank
I have a collection of Smartsheets that I use to track lab testing for each lot# of product. I'm trying to use the following formula to pull the latest result from sheet "ResultImport". =INDEX(COLLECT({ResultImport pH}, {ResultImport ProductLot}, ProductLot@row, {ResultImport CreatedDate}, MAX(COLLECT({ResultImportโฆ
-
ROI Formulas
Guess what...it's me again. I need some help getting these two ROI formulas to work. Any idea why these are coming back as unparsable? Also how should they be? Formula 1: =IFERROR(IRR([Column2]28:[Column4]28),0) Formula 2: =IFERROR((SUM(Column3]23:Column3]27)+SUM(Column4]23:Column4]27))/C4,0)
-
Simple Children / Parent question
Hi all, Apologies I took a break from working with SmartSheet for over a year and am slowly getting my memory back on how the formulas work. I have column called Helper, and in the CHILDREN cells it may say "Yes" if certain criteria are met. I want to have at the PARENT level, either in that column or a new Helper2 column,โฆ
-
Totaling # the of projects that are older than 30 days, 365 days etc
Goal: how many open requests are older than the specified # of days old, this formula returns a result, just don't think it is the correct one as when I try to duplicate it and ask for requests more than a year old, the number encompasses ALL open projects in the last 365 days not the ones specifically older than a year:โฆ
-
Duration formula tied to allocation percentage
I am trying to create the correct formula tied to the percentage allocated for each task for the full duration For example the total task has a duration of 54 Days. The Create task allocated .75 of the total duration (which is the same cell for each task) but I am not sure what formula should be put in the allocationโฆ
-
How to place a Sheet Link in a Report
HI Team, Could someone guide me as to the best way to add a sheet link to a report so that I can access the specific Smartsheet with one click on a report. So for example I have a sheet where the project is running behind and the RYG ball is red - I want to be able to click on the link in the report and go straight to thatโฆ
-
Change Date column if new row is added after hours
Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day. Case: Form Entry happens at 2:30pm on 07/27/23. Start Date column should read 07/27/23. Form Entry happens at 4:30pm on 07/27/23. Start Date column should read 07/28/23. So we wantโฆ
-
COUNTIF and OR or IF Formula
I'm looking to use COUNTIF to calculate if something is the right date and then if it has meets one of the following criteria (using references). My current formula looks like this: =COUNTIFS({Despatch Report Date}, =Date8, {Despatch Report Lot Status}, "Q", {Despatch Report WO Status}, <99 I basically want to count if itsโฆ
-
Formula Support
Hello, I need support on writing a formula. I want the status of the parent task to always be "Review" until all children tasks say "BI/DS/OPS Data Validation", then I want the parent status to change to "BI/DS/Ops Data Validation." When the parent task is marked complete (dark blue row), I want all children tasks to sayโฆ
-
Parent Status based on Children Statuses - Need help refining this formula
Hey Smartsheet Community! I have a beast of a formula that has probably gotten a bit away from me, but I need help refining this so it meets certain criteria per our stakeholders vision. Here's the formula: =IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "Complete"), "Complete", IF(COUNT(CHILDREN()) = AND(COUNTIF(CHILDREN(),โฆ