-
How to use INDEX, MATCH and MAX to display newest form entry if cells match
Here's the setup Sheet 1 Columns: Created [standard] | Name | Form Entry Sheet 2 Columns: Name | Form Entry Display MATCH Name:Name and take the Form Entry with the most recent Created i.e. the newest entry Ideas?
-
Conditional Linking?
Hello, I was wondering if there was a way to unLink cells if a condition is met, i.e. if Column1 is checked then UnLink all cells in all rows this would be to lock values coming in once checked or if that is NOT possible ... If a value that comes into a linked cell (from another sheet source) is say $10 and I set up an…
-
Nested If/And but need and And/Or
I am trying to have the Opportunity Status ball automatically turn green when the four columns to the right are Green OR Gray. I can get the formula to work with just "Green", but when I try to put the OR "Gray" into the formula, it results in a yellow ball or unparseable. =IF(AND([Commercial Business Case Completed]1 =…
-
determine total % project completion using average
I am trying to calculate the % complete of a project across multiple smartsheets. I am using formula: However, it only winds up counting the %values in these cells. For example, the first project is 9% complete, the second is 1% complete, so it returns the value of 10%. if you average these percentages, then the value…
-
Maxing Out Cross Reference Sheet
Hi! I'm using an Index Match formula to pull info into a roll up sheet: =SUMIF({AC 2020 Priority Hotels}, "Complete", {AC Jan ITR}) / COUNTIF({AC 2020 Priority Hotels}, "Complete") However, I'm getting this error message: The max is around 25K cells which I definitely don't have in my sheets. However, when I cross…
-
Help: #INCORRECT ARGUMENT SET
Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), "", IF(ISBLANK([2nd PRODUCT OWNER APPROVAL]@row), "", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED",…
-
Formula Autofill Fails with Sheet Summary References
I have information from my project information sheet (Project ID, Project Manager, Project Name...) linked into the sheet summary of my schedule, risk, issue, and other project management sheets. I then link this information into the sheet via the formula =[Sheet Summary Field Name]#. Otherwise associating a particular…
-
using the SUMIF formula to pull data from another file and display in a separate smartsheet
In Excel I can use the SUMIF formula to calculate data from one spreadsheet and show the sum in another Excel file. Excel Formula =SUMIF('2020 Data'!B:B,A5,' 2020 Data'!F:F) - Column B has Supplier List and Column F has all the amounts of spend by PO number in Column A When I try with Smartsheet I keep getting #UNPARSEABLE…
-
Allow updates on demand rather than using weekly automation
Is there an ability to allow not SS users the ability to update their assigned data elements on demand or does it have to be done via a workflow that runs on time based? Many legal team members need to update on demand for legal 'tickets' - is there a way to allow them to do so on demand?
-
Recreate an "IF" excel formula
How would you recreate this formula within Smartsheet? =IF(LEFT(T2,4)="Uber","Ride Share",IF(LEFT(T2,4)="Lyft","Ride Share","No")) Context: I need to know if on this row in column [Chain] if it says "Uber", notate "Ride Share". If it says "Lyft", notate "Ride Share". If it has anything else, notate "No". T2 would be my…