-
IF Statement Limitations?
I would like to write and IF formula in one column that involves 3 other columns. I'll do my best to explain what I am trying to do and the issue I am running in to. The first column is called "Building" and this is where I am writing the IF formula. The second column is called "Work Center" and its a drop down list of 36…
-
Building a formula to connect multiple cells between sheets
I understand that Smartsheet is not automation tool, but would like to make team's work easier without having to enter lots of information manually. Situation is that that we have two files: pipeline and quote. Once the quote is completed, there is a series of Values, about 40, which need to be called up on the Pipeline…
-
Formulas are not copying to new entries for forms.
Every now and then, new form entries in my sheet will have some or all formulas missing. I add all new entries at the top of my sheets, so there are never any "blank" rows between that and the one below. I have an integration solution set up keying off of some of these formulas, so whenever they fail to copy, that gives me…
-
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?