-
Two new functions released (COUNTM & HAS)
Hi everyone, I noticed that two new functions has been released. COUNTM and HAS Here are the details. COUNTM Counts the number of elements in a multi-contact or multi-select dropdown column cell or cell range. Returns the total number of elements found. https://help.smartsheet.com/function/countm HAS Search for an exact…
-
Mathematical formulas for SS
Hi Team, Would we be able to have mathematical formulas like TAN and ACOS please? Anything similar to excel. Currently we have a calculator to get some figures but we have to export into excel and then import them back into smartsheets. Thanks,
-
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…
