-
Formula on deleting the entire rows if the checkbox is ticked
Hi Team Is there a way that the rows can disappear after we’ve ticked them delivered please?
-
IF/OR Formula help
Trying to Auto-fill a value in one column based upon "fixed" drop down list of values from another column. So this is the formula I am starting with. =IF([Product Family]1 = "7765", "252 Industrial", "265 Commercial") I have (3) additional values I want to include that will satisfy the true portion of the formula. How do…
-
Strip out @domainname.co.uk from Contact
Hi I have a sheet with a column for 'created by' (for form entries) and need to be able to strip out the @domainname.co.uk text so that I'm just left with the individuals name in a separate column. Ideally, I would also like to add a space between firstname.lastname at the same time. example:…
-
Issue with Collect formula
I am having an issue with a formula that I believe to be a bug. =LEFT(JOIN(COLLECT($C:$C,$Created:$Created, NETDAYS(@cell, TODAY()) <= IF(WEEKDAY(TODAY()) = 7, 2, IF(WEEKDAY(TODAY()) = 6, 1, WEEKDAY(TODAY()) + 2)), $A:$A, $[Work Description]@row))) Does not work, it propogates an error in the cell. If I rearrange the…
-
#Invalid Value in Index Match
Hi Smartsheets Community, I am trying to write an index match that looks at a row that either says yes or no (only one column says yes) and return to me the corresponding value in the column below it. I currently wrote =index([column name]#:[column name]#, match("yes", [column name]#:[column name]#, 0))) I keep getting an…
-
Countifs Formula Help!
The current formula is: =COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete") I need to count anything that is passed due and not closed, lesson learned or duplicate. I am utilizing a drop down box, too. Thoughts? Branden
-
Countifs counting
I am trying to count criteria in a couple different cells on my smartsheet. I am using the formula below: =COUNTIFS(RAID:RAID, "Action", Disposition:Disposition, "Open", Disposition:Disposition, "Retest", Disposition:Disposition, "Post Go-Live") I am trying to count any Risk, Action, Issue, & Decision and also factoring in…
-
Multiple If Statements
I'm having a difficult time making multiple 'If' statements work, cross sheets. I would like the sum of a column to be brought over to another sheet IF it meets the following criteria: 1. meets a corresponding category, and, 2. has a check box. The first half works (below), without the check box being checked: SUMIF({LGES…
-
Check boxes and formulas
Hello We are using Smartsheets to build ships.. but I have an issue with the formula(S) I want to be able to use a tick box for a formula.. We have many options priced and I want to use the tick box to generate option pricing. If the box is ticked then the price will move to the next column that is auto summed. If its not…
-
Whoaou !! whats happening with the Forms ???
Since 2 days when I add a row on the top using a Form the sheets are disorganized and the formulas are destroyed...am I the only person to have the issue ? When I had by the bottum, the formulas are not copied... It was workin until last week My sheet is in place since sevral week and got 500 rows No answer from the…
