-
row sorting is juggling formula
We have created a sum function in a row that has been copied down for 100 rows. We are only reading data from each row......not holding a cell from a previous row. When sorting and filtering throughout the day, we are finding that the sum functions are trying to read previously held row designations. Row 10 may read the…
-
IF formula combined with dates
Hello, I need help. I am wondering how can I create a formula using the IF function with a range of dates. For example: If the date is between 01/01/2018 and 03/30/2018, then write 1st Quarter., and if the date is between 04/01/2018 and 06/30/2018, then 2nd. Quarter, etc.... Thank you in advance!
-
COUNTIFS / Referencing data another sheet
I'm still pretty new to Smartsheet. My goal is collect data from another sheet in an easier to read format but I cannot get my COUNTIFS formula to work. If I do separate formulas for each criteria it will work but not when I attempt to combine the formulas to look at 2 criteria's it fails. I have columns on the referencing…
-
Using reports to create Totals
Hi I am pretty new to Smart Sheet and have mainly used it for Project Plans so far. I am now looking at using it for forecasting for delivery consultants. I have created a sheet and form for them to enter forecasting for delivery for a particular customer in a given month. I would however like to be able to create a…
-
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?
