-
Identifying duplicates between 2 multiselect Dropdowns
Hi there. Really hoping you can help as I am a little stuck here. We are using a smartsheet to log and plan change requests across a wide variety of applications. A single change will only ever be a single row with it's own start and finish dates. A single change may affect multiple applications and some of these…
-
Need help with formula/function to determine RAG Status
I am trying to put a formula to determine the RAG Status in the project plan . It has the start date , end date & dependencies enable. Below is my requirement, For computing the overall RAG status at a rollup/parent activity level, the status of only those activities that are in critical path to be considered .So is there…
-
COUNTIF from multiple sheets
Hi, Can someone help me on my below formula please! Scenario: I have a UATStartdate in multiple sheets and I want to store "Overlap" in my UATOverlap column if UATStartdate clashes with other sheets. I am using below formula in UATOverlap column but getting "UNPARSEABLE" error! Kindly help =IF(COUNTIF([UAT Start…
-
Sum Collect if two different values met
I have added this formula: =SUM(COLLECT({Sheet - Sales Pipeline Range 10}, ({Sheet - Sales Pipeline Range 5}, "Closed Lost"), ({Sheet - sales pipeline loss reason}, "Price"))) I am trying to sum all values from Pipeline Range 10 column that have met the criteria of "Closed Lost" with the loss reason of "Price". What have I…
-
Where is my mistake ???
Hello to all, Could someone please tell me where my mistake is, please ? =IF(OR(Résultat@row <= "69,99%"; [Compteur Non-Conformité]@row > "0"; "Rouge"; IF(AND(Résultat@row >= "70,00%"; [Compteur Remarques]@row < "1"; "Vert"; "Jaune")))) Thanks Christophe
-
COUNTIFS in a Date Range
I'm attempting to count how many times a sales rep's name appears in a column and the deal they're working on will be closed within a date range. I'm using a countifs statement with an AND for the criteria on the second range. I receive an INVALID OPERATION result when I use AND, but if I only look for either greater than…
-
Possible to automate new rows in a sheet to be child rows if a cell value matches an existing row's?
To elaborate, we have a setup currently with our source sheet that creates a new row into the target sheet with Zapier, triggered when a PO# gets manually added to its PO# column. However, in some cases, the PO# that is added to a row on the source sheet is already on an existing row on the target sheet, and we want to be…
-
USE OF ISBLANK FUNCTION WITH HAS FUNCTION IN SAME FORMULA
Hi, I desperately need help to figure out the use of the ISBLANK function jointly with other functions. I'm fairly new using it. I have a table that has three possible values, Yes, No or the cell is still blank as we are filling the table. The purpose of the table is to track the result of an inspection in a project.…
-
Nested If with Vlookup
If statement with Vlookup as the true value. I have a sheet that is doing a vlookup from one column but if one criteria is met, then I need it to vlookup a second list. I'm using this for the main vlookup: =VLOOKUP([L2]@row, {POC}, 2, false) and if Last, First is the name in L2, then I need it to look at L3 and retrun that…
-
Date Format
Hello, The data that gets imported has date list with time (example: 11/20/2019 7:45am) I only care about the month/day/year. Is there a way to have the extra data removed? In excel I use the delimited feature. Hoping Smartsheets can accomplish this easier.