-
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…
-
Drop down list with hierarchy
I want to create 2 related drop down list, For example, first column drop down "A, B , C" choice, 2nd column have "A1, A2, B3, B4, C5, C6. When I choose "A" in 1st column, only "A1, A2" can be chosen in 2nd column. Is ti possible? Thanks. Daniel
-
Form fed info to build a "Final Assembly" from multiple parts
New to Smartsheet. Have 30 sub-assembles to choose from to create 50 final assemblies. Each "final assembly" is custom and unique. I would like to feed answers into a form. The answers would pull only the relevant sub-assemblies from the 30 sub-assembles so I can CHOOSE which of the relevant sub-assemblies I want in order…
-
Calculating % Complete (Plan) Formula For M-F Only
Good Smartsheet Community: Are there Any Modification I Can Make to this Formula so that it skips Saturday and Sunday when Calculating My % Complete (Plan)? Current Formula: =IF(IFERROR(IF(AND(TODAY() >= [Start Date]@row, TODAY() <= [Finish Date]@row), ROUND(NETWORKDAYS([Start Date]@row, TODAY()) / Duration@row, 2),…
-
Automation in Workflows
How can I Request an update to separate person as per the specific data in the form. For example, we have 4 department named Dept 1, Dept 2, Dept 3, Dept 4 and we have 4 separate managers for each department M1, M2, M3, M4 respectively. Now, when the form is filled up and in the department section, Dept 1 is selected, than…
-
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
-
Alert Someone with Past Due items with Filter
I have a SS that I alert all on Mondays of what items that are assigned to them that are past due. When they click the "Open Update Form", I would like the filter of "Past Due Items" to automatically show them only the past due items. Can this be done, and if so, how? Thank you, David
-
Need assistance creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields. The status column has three options: Not started, In progress, and Complete. If Columns A, B, and C are blank, I want the status to automatically change to "Not started." If Columns A or B are not blank, I want…
-
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…
-
Health status formulas and automation
Hello anybody, Please help me with automation formulas for the Health column? I'm very new to Smartsheet and struggling a bit! I'm trying to do the following: Red flag - when the date has passed Yellow fag - when the date has not passed Thank you