-
How to count multiple columns
Hi, I am trying to count the number of users whose activity is greater than 0 for the past 3 months combined. Is there a way to use COUNTIFS on multiple columns?
-
Mathmatical formulas in Smartsheet
Hi there, I am attempting to make a calculator in Smartsheet using formulas like TAN and ACOS. These work in Excel but not in Smartsheet. Does anyone know any work arounds?
-
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…