-
Count anything that is passed due excluding certain criteria
It is not supposed to count anything that is closed, lesson learned, or duplicate. The current formula is: =COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete") This formula is counting those things, however, I need to count anything that is passed due and not closed, lesson learned or duplicate. I am…
-
Percentage
Hello! I have a question, is it possible to create a percentage for symbols? I've been trying to create a percentage of items that are high priority, which would be displayed as a red flag. This would all be displayed in both sheets, reports and on my dashboard. Thanks for all the help in advance.
-
Cross sheet reference multiple cells by dragging
Hello everyone, I would like to reference multiple cells in the same column from sheet B onto sheet A. I thought I could create a reference formula on Sheet A to pull the value from sheet B and then drag that same formula down onto the rest of the cells but noticed that the formula does not change if it is dragged. Is…
-
stop counting outstanding days when task is complete
Hello All, I am using this formula =TODAY() - [Date Field Checked]3 but I need to stop this count when the item is complete. Could someone please help out?
-
COUNTIFS ON MULTIPLE COLUMNS REFERENCING A DATE RANGE
I am trying to summarise a Smartsheet that we log sales activities (F2F Calls and Phone Activity into). So I want to see how many Phone calls have been done in the current month. 1. What is the most efficient way to achieve this? I have used the below formula to get June Activity, but when I try and reference another…
-
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…
