IF(
Discussion List
- Hello, I'm trying to make an IF( formula for the following criteria. If Tech is YES and Curved is YES, 650 If Tech is YES and Curved is NO, 500 If Tech is NO, 0 Thank you!
- I am trying to write what seems like a basic formula, but I'm not getting the expected result. I would like to reference a Contact Cell column with an If(Contains) formula. The basic formula I have wr…
- I'd like to select text in a column based on symbol indicators in a column. For example if they are highly impacted, with a "!" symbol and they are not influential with a (down arrow) symbol, i want t…
- Just recently, we have been experiencing automated workflow messages triggered based on formulas that are years old 😯 It appears that these messages are triggering each time a user sorts the originat…
- Hi Smartsheet community. I have been working on a formula and it has not been working. Wondering if I am going about it the wrong way? I am working on a lessons learned project sheet where i am confir…
- Hi, I need assistance with assigning a score for outputs using a multi-select dropdown menu. Essentially, I want to be able to assign a numerical value when someone selects a choice from a multi-selec…
- Hi, Thank you for coming to my help, I really hop this question makes sense. Basically, what I want to do is take the closest date of incomplete tasks and put it into another sheet where I can run aut…
- Got burnt out looking for my exact scenario in the forums, so looking for direct help. Trying to create a formula to automate my Health column KPIs based on task status and assigned dates. Status opti…
- Hi, I have two sheets, one is an intake sheet and the other is a metrics sheet. Metrics Sheet Plan has an OR(ISDATE( Formula to raise flag is a date is entered Agents has an IFERROR(INDEX(DISTINCT for…
- I have a sheet (See below). In the 'Sheet Needed' column I have a formula: =IF(P@row = 1, COUNT([Sheet Created?]@row, IF(P@row = 0, SUM(CHILDREN())))) This is working in the Child Rows, however I am n…
