-
If Formula with Dropdown conditions
I am trying to get an IF statement to check conditions of 3 dropdowns and based on those being true either add a specific value or do a calculation. Below is what I am trying, but I am only getting it to populate N/A, no matter what the values entered are. If the 3 that are entered below are true it should enter the value…
-
I want to link the same cell repeatedly. Is there a formula that hyperlinks or cell links?
I'm hoping there is some kind of formula that would make things som much easier.
-
DATEONLY returning an error
This discussion was created from comments split from: Where is the "today" default date for forms?.
-
Can we pull date stamps?
Good Morning, I am a project manager, and I want to collect the timeframes in which my designers and checkers take to complete a given task. However, I would like to know how much time the designer works on it, how much time the checker takes to review the drawing, and then how much time does the task sit idle. I have them…
-
I would like to add on to this and count unique values (ie. repeated cells counted oncely once).
=COUNTIFS({LCS}, $[Primary Column]@row, {Phase}, ISBLANK(@cell)) What can I add to do this?
-
Countif logic not working
Hi Team, I need a formula that should count the based on Priority High, Medium, Low . So if the priority is High and Status is Completed it should count the number on closed column if the priority is High and status is In progress,Hold its should count the number on open column like wise we have to do for Low and medium.…
-
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…
-
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…