-
Formulas
In Excel, when you create a formula, you drag it down so it is the rows below. In Smartsheet, I don't think that is the best practice. How do make sure the formula will be used, but that I don't need to drag it down like in Excel?
-
Sheet summary formula to add number of attendees based on a program type?
I am trying to count number of attendees (one column) based on a different column (program type) we have running ("A" vs "B" vs "C"). I am getting unparseable. Any suggestions? I am trying to use the below formula: =COUNTIF((Program:Program, "A")) (AND(=COUNTIF(Number of Attendees:Number of Attendees, >0) I have also…
-
Why is my automation to copy rows to other sheet missing data from certain columns?
I have an automation created that, when a row is added to sheet 1, the row is copied to sheet 2. Its working fine except it sometimes misses values from the "First Pay Date" column and the "IC" column and they dont get copied over. They will just be blank on sheet 2. I made sure that under column properties, they are set…
-
Need help getting a percentage of checkboxes
I have a column with check boxes. I want to get a percentage for total number of boxes that are checked vs the total number of boxes (checked or unchecked). I want this in the parent row to count the children rows only. I got the below formula to work however when I go to use the percentage in a pie chart it wont accept…
-
#Incorrect Argument Set
Hello All, I thought this would be a simple task, but about three hours in of trying to figure this out, I'm at a loss. I have a total of 5 sheets, 1 reference sheet and 4 intake sheets created from the reference sheet. I'd like to take the information from the 4 sheets and "link" them to the reference sheet by title…
-
Combining Data from a Group of Cells based on Another Cell's Data
Hello Smartsheet Community! We have a situation where we have a column A for Shipping Options (Store or Other). We have column B that is combining other shipping details from columns C-H . If column A is listed as Store, we do not want column B to combine the data from columns C-H, it should remain blank If column A is…
-
Count IFS and Count IF
I have a formula that is counting, for a specific criteria (see below), in a specific column; however, now I need it to look in a 2nd column and also include it in the COUNT; however, I do not want it to be "double-COUNTED". For example, if the amount will always appear in Column 1 and then eventually appears in Column 2…
-
VLookup in 2 different sheets based on a property code
Hi, I am running a Vlookup on one sheet from 2 different reference sheets depending on the property code. If the data is missing in those sheets it should return a NO. I have done this formula but I am still getting an #unparseable error... =IF(ISERROR(VLOOKUP([Position ID - DO NOT LEAVE BLANK]@row, {IF(Property@row="SDI",…
-
Calendar Help
Hi all, How can pull data from 1 cell to a calendar on another sheet on a date selected from another cell. To try and explain, see below. i want the job info to go to the calendar sheet on the job date day. hope this makes sense!
-
Change date based on IF(AND formula
Hi, I have a problem with my formula and I really hope you can help. So basically looking at my formula, the “{2B-0.5 Service Parts Order (Oct) Range 1}“ is the part number (reference to the column in different sheet) and it needs to be the same as the part number column in the sheet where the formula is, {2B-0.5 Service…