-
vlookup - changes on source file
Hi, I've noticed that when you insert a column in one of the source files all vlookups in other sheets will reference an incorrect cell. Either it should be smart enough to know the change on the source and change it's formula or at least give us an indicator the reference changed so we can take actions to correct. Any way…
-
Checkbox autochange status
In my sheet I would like the 'Status Level' column to autochange to 'Complete' when the checkbox for completed is checked off. Is there a formula to so this with?
-
Counting Past Due
I am trying to count anything that is a past due task, but not counting items that are closed. What is the best formula to use? My current formula: =COUNTIF(Due:Due, <TODAY(1)) BUT this is counting all items that are due past TODAY. Any pointers?
-
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…