-
How to Create Formula to return Fiscal Week
I have 1 column with Start Date for Fiscal year & week 2nd column is end date for fiscal year & week I want it to return 3rd column where i have FYYRWK This is all housed in a separate smartsheet. Ive tried a few different articles on smartsheet, but cant seem to get one where i want it to be = or Greater than & less than…
-
Excluding Blank Cells in Formula
I have a master row that I would like to track the year's progress. In my image, I would like the [Status] ball to stay Green if "YES" and if blank in [Count] cells January - December. Want it to turn Red, if there is a "NO" in any [Count] cell. If all [Count] cells are blank January - December then "Blue" YES followed by…
-
COUNTIFS Formula For Total Number Of Assigned Projects To Individual
Hello, I am trying to troubleshoot a formula to achieve the following outcome. Outcome: Count the TOTAL number of rows in which [Assigned To (In-House Designer)] is "Danielle Morrison" AND the [Request On Hold] checkbox in UNCHECKED. Background Information: The Assigned To (In-House Designer) column type is a Contact List…
-
Limiting the Quantity Selection on A Web Form
Hello! I have a form that allows users to select up to 5 types of shirts. I want to be able to limit the amount. So if for the green shit they select 3 shirts, for the red shirts I want them to only be able to select up to 2, and that would meet the 5 count. Does anyone have an idea on how I can do that?
-
Conditional links on forms
Hi, New to Smartsheet, is it possible to link fields on a form based on conditions i.e: - If user selects 'Production' from the field 'Employment Department' then mandatory that must select a 'Production Shift' (i.e. one of following Green,Purple,Red,Blue,Yellow) - Else if 'Employment Department' ≠ 'Production' then…
-
Workflow - lock/unlock rows
Hello, First of all thanks for helping :) I have this list of tasks where i use my WFIndex + Index columns to identify them and execute automations. My Milestones are "locked", colored in blue and in this case identified by WFIndex = 4 (row 8) I have a few "checks" which i want the user to mark as "completed" before…
-
How To Identify Max Value
Hello, Need help, I want to identify which questions have the highest "No" respond. On column "MAX - NO" will appear the name of the questions that have the highest No respond. Currently, I can identify the maximum of respond on each questions. I don't know which suitable formula to combined with MAX to capture which…
-
Raise Flag: If and statement
Trying to put in a formula that raising the flag if the end date is past the deadline and status is not marked as complete. This is the formula I have =IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete"), 1, 0)) but it is returning #UNPARSEABLE
-
JIRA smartsheet connector with Formulas
Hello, I'm currently attempting streamline work status changes with Smartsheets as they are integrated with my JIRA instance via cloud connector. The way we currently run our projects within JIRA (that are synced to Smartsheets) is by creating "Epics" that have "Stories" mapped to them(as children). Through using the…
-
IF Formula (Due Date > Today's Date AND Request On Hold (Box Checked) = No Flag In Past Due Column)
Hello, I am trying to troubleshoot a formula to achieve the following outcomes. Outcomes: If the Due Date column is past today's date, trigger a flag in the "Past Due" column. HOWEVER: If the "Due Date" column is past today's date AND the "Request On Hold" column has a check box, NO flag in the "Past Due" column. Database…