sharkasits✭✭✭✭

Correct...I found a solution that worked for this instance, comparing the the category to the ID to eliminate the older versions and it looks like the largest number of each category is at the bottom even if they aren't in order so I'm just taking the last match. It seems weird that MAX wouldn't just work alphabetically…

@Paul Newcome It came from a historical manual process in google sheets. So it was an uploaded sheet.

I think the formula for this gets pretty complicated in Smartsheet, so I would us a helper column to indicate what value it will match on. Formula for Helper Column: =IFERROR(IF(MATCH([Entered Value]@row, {Headers}, 0) > 0, [Entered Value]@row, "Issue"), IF(([Entered Value]@row - MAX(COLLECT({Headers}, {Headers}, <[Entered…

@Charles_M do you have other fields that would be filled in or blank based on if there are 1 or 2 tenants? If yes, I would capture if there are multiple tenants in a checkbox and then use the following: IF([Multiple tenants]=1, IF(AND([COMPLIANCE DATE ACCEPTED TENANT 1]@row = "Confirmed", [COMPLIANCE DATE ACCEPTED TENANT…

@Bob White You aren't doing anything wrong. All three of those actions end the workflow. You can have 3 automations that are all triggered by the same thing. It would be nice to be able to do them all in one automation though.

@CDS can you screenshot the formula you put in? Sometimes when you get that error it's a syntax error (like a missing quotation mark or comma in the wrong spot). Also, just to confirm, the Jan Billing Date column is a Date Type, right?

@CDS is there only ever 1 date for January, or could there be multiple? If it's only ever 1 date, you should be able to just change your "0" at the end of the INDEX() to a 1.

@Diane Mooree I think this should work for you. If you create a helper sheet that has 1 row with two columns. Column A (Date): =TODAY() Column B (Checkbox): =IF(DAY([Column A]@row + 1) = 1, 1, 0) Set an automation to run daily that copies the row to your summary sheet if the box is checked.

@pgeorguson It's still working for me. That's a browser supported attribute that I believe all major browsers use. Are you using something other than a major browser?

@laura。桑多瓦尔回到这s... glad it worked for you. The closed parenthesis in the wrong place gets me all the time too. @Genevieve P. thank you for adding clarity to the formula!!