エンタープライズ向けに構築

Variance on time or behind schedule collumn

01/20/25 ... Perfect - This does exactly as asked. ... Apologies for not including this in my original request, I had an oversight to not include anywhere whereby the column "status" @row = "Blocke...

Need formula to remove characters from a column when added

Will it always be all text after the < or > that needs removed? ... Correct. ... The people using the form just cut and paste the data in the column and we are trying to elimintate them having to m...

How do I add a date range formula to an existing formula?

How do I add a date range formula to an existing formula? ... It looks like you are using Excel syntax. ... I removed the first two {Ranges} because you have no criteria for either of them. ... Wha...

Form Submitting Error when attempting to submit with an attachement

01/20/25 ... Hey @NickBlocker ... I'm unable to replicate what you're seeing: as long as the file is under 30MB then the Form submits without an error. ... Is this still happening for you today? .....

Formula help - How to return which Financial Quarter a project Start Date falls into

@Tara Factor I also thought of a more elegant solution that will allow you to use your second sheet and keep adding new quarters as you identify them that way you don't have to keep modifying the f...

How to combine sum if formulas

01/20/25 ... It looks like it is the dates. ... Would need to make your dates as >=Date(YY,MM,DD)

Formula help on RYG Balls for Baseline Variance

Create a helper column and use this formula: ... Then base your IF statement on the formula. ... You could also build the formula into your IF statement to avoid the helper column. ... 0 ... 01/20/25

countifs help

@tracyashton The other thing I thought about is if you need to return a total that consists of all of the cities you listed you could use COUNTIFS with an OR function, as pictured below. ... That w...

Countifs return 0 out of nowhere

01/20/25 ... Your formula looks fine, but that would make sense if it were previously working. ... Is it possible something changed in your source sheet? ... If it is populated by formulas or data ...

Trying to create a summary of data from another sheet

01/20/25 Answer ✓ ... Melissa, I had a pro session this morning, and you were right on. ... Here is what he came up with: ... IFERROR(INDEX(COLLECT({RF#1}, {Client Name RH}, [Client Name]@row, {#Ro...

Combine Multiple IF statements

01/18/25 ... Give this one a try: ... =IF(AND(OR([Procurable]@row = "YES", [Procurable]@row = "TBD", [Procurable]@row = ""), [Spend]@row >= 100000, [Contract Type 1]@row <> "", [Contract Expiration...

Count # of cells approaching a date for sheet summary

Count # of cells approaching a date for sheet summary ... Isis Taylor ✭✭✭✭✭✭ ... 01/18/25 edited 01/18/25 ... Are you trying to determine if the date within the off-site cell is less than a week fr...

Index(Collection formula for dropdown field with multiple entries

Index(Collection formula for dropdown field with multiple entries ... What are you expecting for the final output? ... How are you needing to leverage this multi-select field? ... so I have a list ...

Date Formula to always return with next Friday Date?

What if the date is a Friday date? ... Would you want 1 week in the future or two weeks in the future? ... CERTIFIED SMARTSHEET PLATINUM PARTNER ... =(Date@row + (6 - WEEKDAY(Date@row))) + IF(WEEKD...