-
Count checkbox and text in a column
Hi, is it possible to count in a column, if I have check box and also N/A ? I need to count every cell that has a check in the box or the N/A. Thank you !
-
Output combined column name values from checkboxes.
Hi, I have a number of checkboxes, if they are checked I want to output the column value in another cell. I understand we can't reference the column values but I am able to do this: =IF([Red]1, "Red") This will return a single value if the checkbox is true. When I try something like this: =IF([Red]1, "Red", IF([Green]1,…
-
Stuck on If Statements
Hi team, I'm building a dashboard and I need to show the current metric. I thought I'd show this by showing each month (for a chart) and using this formula to obtain the current: =IF(DEC3 = "", NOV3, IF(NOV3 = "", OCT3, IF(OCT3 = "", SEP3, IF(SEP3 = "", AUG3, IF(AUG3 = "", JUL3, IF(JUL3 = "", JUN3, IF(JUN3 = "", MAY3,…
-
Workday formula gives me #UNPARSEABLE
Hi. I'm trying to calculate a Deadline date based on varying lead time (calculated separately in another column). I have a confirmed lead time column (can very between 4 types) and a deadline calculation column (IA Date Calculation) using "IF" formula (if 8 weeks lead time = 5 business days, if 16 weeks = 10 business days,…
-
Advice Needed to Optimize Workflow
Hello, I am looking to build a workflow for a review process in Smartsheets. There are multiple stages to this review process. For example, the item is submitted for Group A review. It must be approved by Group in order to be Submitted to Group B. What would be the best and most user friendly way to track who is reviewing…
-
Formula for selecting correct Image
Hey folks looking for IF statement that would allow me to specify a number ranges from one cell that contains a number to then display the appropriate Arrow. Any help in changing the formula would be great. Below is not correct but hopefully gives you the idea =IF([Heat#]1 <= 4, "Down", IF([Heat#]1 <= 8, “Angle Down”,…
-
How to use vLookup for other sheets
Hello, I've been trying to use vlookup to find data from a datasheet Sheet A contains a column 1 with "My Name". Sheet B contains column 1 with "Name" and "Number" I want a column in sheet A that looks for the corresponding name in sheet B and returns its number. I've looked up tutorials on this but there doesn't appear to…
-
Does a range of dates fall between another range of dates?
Hello, I have a need to be able to highlight if a range of dates falls between any other range of dates. I have a checkbox column which needs to be ticked if a range of dates conflicts with other range of dates. So for example, we might have a number of projects running throughout the year across different clients and…
-
Parent/Child References
I am trying to use COUNTIF to refer to the number of projects that are under a certain parent row. I am having a hard time not coming up with a #INCORRECT ARGUMENT SET error.
-
Countifs with Multiple Criteria in the Same Range
I am trying to create a formula to count the number of projects assigned to one person based on the phase of a project. My criteria is that is NOT one of the following phases: Construction, Completed, Punch, On Hold. I know I need to use <> to create the "not equal to" but for some reason, I am missing something to make it…