-
Coding for Health symbols
I am BRAND NEW to Smartsheet and am looking for a way to code my sheet so that whenever a new entry is submitted via the form, the Health Status symbol is automated to the color Red? I also can't seem to change the color of my forms no matter what I choose to do in the Colors and Logos it always ends up White! Muchโฆ
-
How to copy paste a SUM function that is referencing to other sheets
Hi all, I have sales data per month for a year, for several regions, each region has its own sheet. When I want to make 1 summary table, I think I need to use =SUM(number 1, number 2, ...and so on) and for each number, reference to another regional sheet. In Excel, if I create this formal for January once, I can then dragโฆ
-
Help with Formula: COUNTIFS using date range and single dropdown data
I'm trying to figure out a formula to count how many projects occur within a specific date range as well as have one of three different payment status'. Here's my working date range formula. I'm trying to AND the date range with the three OR'd payment status'. =COUNTIF({EISD}, AND(@cell >= DATE(2021, 5, 1), @cell <=โฆ
-
Cannot calculate checkbox column
I am trying to calculate the number of checked cells in a column (named 'Done'), however I keep getting errors! The checked ('Done') column in question is pulling from another sheet using index links so will throw up a tick in the check box and a #NO MATCH accordingly. The calculation i am using to pull from the checkedโฆ
-
IF AND Formula
Hi Team, I am facing #UNPARSEABLE error in my smartsheet formula. Below is my formula created in smartsheet which I would like to show logic as below: Influence High + Interest High = 90 Influence High + Interest Low = 180 Influence Low + Interest High = 180 Influence Low + Interest Low = 365 =IF(AND([Influence (in termsโฆ
-
How to count newly added tasks and closed task for previous week.
Hello, Can someone help me to create formula for my requirement. Everyweek starting on Monday, I need to look for how many tasks were added and how many were closed in previous week. I attached sample xls sheet. As we know everyweek some tasks will be opened and some tasks will closed. I would like to see a summary of theโฆ
-
How to use a populate a column in a smartsheet by using a formula.
If column b is required to be exactly 6 months after column a. Column a was specified in a form. Is there a way to insert the following formula into the column or worksheet: =IFERROR(DATE(YEAR([Last Calibrated]@row), (MONTH([Last Calibrated]@row) + [Calibration Cycle]@row), DAY([Last Calibrated]@row)), DATE(YEAR([Lastโฆ
-
Using SmartSheets to ping an alert 3 weeks prior to due date
Hi, I'm currently trying to use smart sheet to ping an alert 3 weeks prior to due dates. I've tried using the alert system to ping an alert but it doesnt seem to work. Can anyone help set up a workflow? AI've also tried setting Condition (1) to a few different things but being only able to test once every hour is superโฆ
-
Using IF, FUNCTIONS (HAS, CONTAINS, etc.), and OR (for searched fields).
Greetings Team, I feel like I'm missing something simple on this one, but it's a general problem that I encounter a lot. For this question, I'm able to construct formulas that Smartsheet accepts, but the current version is long and more difficult to understand/manage from other users. This involves using IF, FUNCTIONS, andโฆ
-
COUNTIFS formula
Good Day I am struggling with the formula below: =COUNTIFS({IDProjet}, CONTAINS("2020", @cell), {IDProjet}, NOT(CONTAINS("E", @cell)), {DateCD-SAM}, >=DATE(2019, 6, 1), {DateCD-SAM}, <=DATE(2020, 5, 31))) I am referencing another sheet. I am having #UNPARSABLE error code. Can't find it. Please help me. Cheers, Claude