-
Trying to Output a text value in a column based on values in two other columns.
I am creating a risk register where Impact/Severity is chosen as a dropdown between 5 values (Severe, Major, Moderate, Minor, Not significant) and Probability is chosen between 5 values as well (Almost Certain, Likely, Possible, Unlikely, Rare) where depending on what was chosen in the two columns an output in a third…
-
How can I calculate the average NETDAYS between 2 columns?
I want to calculate the average NETDAYS between these two columns as a field in my sheet summary. How can I accomplish this?
-
Formula to track issues logged for a specific year ONLY?
Hi! We currently have a log that captures issues for 2022 and 2023. I'm attempting to track our "Ops Issue" and Labeling Issue" categories for 2023 ONLY and am having a hard time with adding additional date criteria to the COUNTIF formula. The screenshot below reflects my latest attempt at capturing the 2023 data. Please…
-
Vlookup from another sheet to copy formula number
Hello, I am trying to determine how to get a cell copied into a sheet from another sheet based on certain criteria using a vlookup formula. Here is the sheet i would want the formula to autofill in. When Gunma (Asahi) and Aussie lemonade are chosen, I would like the formula number to autofill pulling from another sheet. So…
-
Find/Replace on Checkbox Column
Has anyone been able to figure out how to do a find/replace on a checkbox type column? I have tried 1, true, TRUE, True, "1", "true", "TRUE", "True", and none of them seem to trigger a match.
-
Looking for Formula Help - Health Status based on End Date versus Today
Good morning! I am looking for help with a formula as what I have entered returns "Unparseable". I am looking to return colors based on the below: If Status is Complete then "Green" If Status is in Progress but less than TODAY "Red" If Status is Not Started or In Progress and the End Date is greater than today by 7 days…
-
Extract Cell History For Formulas
Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time…
-
Is there a workaround to have a column with date (as function) to be recognised by workflows?
Dear Smartsheet Users, For my solution I need to have a date (always the same) in one column for more than 100 rows. The easiest way for me to do it is to write e.g.: ="03/04/23" and change this column to formula one so the same date will be for next row etc. However despite it's a Date column the workflows are not being…
-
IF AND FORMULA
Can anyone help with this formula please as i have tried to get it to work unsuccessfully but might even be barking up the wrong tree altogether =IF (NOT (AND (G2 = "COMPLETE",C2 < today()),"OVERDUE","")) Basically i want the cell to flag as 'OVERDUE' if G2 does not have complete in it and C2's date is less than today…
-
How do I count the number of times dates appear within a range?
Hi, I am trying to track the number of times a call occurs within a date range in a cross sheet reference formula. The user types the date on the call log and I would like to use the dates as a way to measure how many times calls occur within a week, month, and project to date . I have tried different ways, but I am stuck…
