-
=IF(AND formula for calulating Impact and Probability
I am trying to plug this matrix into a smartsheet: I'm pretty new to formulas but I am trying to construct an IF(AND formula. Below is what I have constructed. =IF(AND([Impact]@row "Low 1" , [Probability]@row "Low 1" , "1"), IF(AND([Impact]@row "Low 1" , [Probability]@row "Medium 3" , "3"), IF(AND([Impact]@row "Low 1" ,…
-
two factor RGB balls formula. Status and Date
I know this has been asked a million times and I have looked at all the other post, but still cant get it to work. Status options are: Not Started In Progress Completed Transferred To Other Department Due date is standard date format I am trying this as the formula: =IF(Status@row = "Transferred To Other Department",…
-
how to clear a cell after you uncheck a box
I have a "Record a date" that populates in a cell when the completed box is checked. If, for some reason, that box is unchecked, how do I have the populated "Record a date" cell cleared? The "Done" box was checked but if the task wasn't actually completed and the box was then unchecked, I need to have the "Completion Date"…
-
Sum extending range
I need a formula that increases the sum range as more data is filled in. The formula must be part of the column, at the top and add data as it appears at the bottom.
-
COUNTIF with HAS Formula in Sheet Summary
I am trying to do a COUNTIF in the Sheet Summary for a column that is a Multi Select Dropdown. I know that you are supposed to use the HAS function, but I can only seem to get that to work in the sheet with @Cell. Any suggestions? =COUNTIF([Department of Concern]:[Department of Concern], HAS([Department of…
-
sumifs formula cross-sheet
Hi, I have a partially working formula from a cross-sheet. =SUMIFS({VENDOR QUESTION Amount of Credit}, {Status}, OR(@cell = "Pending - With AP", @cell = "Pending - With Vendor AP")) When I try and add in these additional columns, I get an error. {Location # and Name}, LOCATION@row Any suggestions would be appreciated.
-
Setting Formula using RYG
Hi! I'm trying to set up a formula using the Red, Yellow, Green symbols but I'm having difficulty doing so with how we use it. So basically, we have multiple columns we use to grade our employees in a QA setting so example Red=No, Yellow=Somewhat, Green=Yes. I am not even sure if this is possible. Any input advice how to…
-
Linking sheets
I have a dropdown box in a column on Sheet A. I want to link Sheet B. When I create a hyperlink to Sheet B with one of the selections from the dropdown, when I go to edit that selection later, the link disappears. I want the link to Sheet B to stay no matter what dropdown selection I choose.
-
Why is my formula #UNPARSEABLE?
=IF(Created@cell < DATE(2021,6,30),"Gray",IF(OR(AND([Priority]@cell = "P1",[Days Since Creation]@cell <= 30),AND([Priority]@cell = "P2",[Days Since Creation]@cell <=45), AND([Priority]@cell="P3",[Days Since Creation]@cell<=60), AND([Priority]@cell="P4",[Days Since Creation]@cell<=120),AND([Priority]@cell="P5",[Days Since…
-
Date Formula
Does anyone have a formula to calculate the date 90 days from current date? Example: Current Date Next Due 02/09/2022 (formula to display) 05/09/2022 Thanks!