-
Count How Many Times a Value Appears in the Column
I have a column that contains a value (Example: "Joe@email.com:iPhone", "Joe@email.com:iPad"), and I want to have a formula check to see if any value in the column appears more than once, or to just tell me how many times the value in that row appears throughout the column. So in the provided example, if those two values…
-
Average of a sheet summary field across two sheets
I have an average calculating in Sheet A. Another average calculating in Sheet B. These averages are calculated in the Sheet Summary currently. I'd like to create an average of these two averages to appear on a dashboard. I don't believe I can do calculations in a report document. I can have this calculation done in either…
-
Generate documents from parent and children rows
Is it possible to generate one document from multiple rows? Best example I can think of would be an itemized order with multiple items in the order - how can you list all order items from that parent row (order number) with the item ordered [qty, price, detail information] on the children rows? Having columns to fill on…
-
Is there a way to copy a single field to another sheet with Data Shuttle or in another manner?
I need to copy a Key field to various sheets at certain points in the processing. We keep having errors on the sheet [running out of space] when everything is on one sheet, so we are separating out based on processing criteria. We do not want all of the row to move, as this is where are trying to save fields and keep the…
-
Formula to drive checkbox if today is between the start and end dates
Hi All! I've looked at prior posts on this topic and have followed the formula advice, but I continue to get an error. Here is the formula I am using. =IF(AND(TODAY() <= [Reporting End Date]@row, TODAY() >= [Reporting Start Date]@row, "Checkbox", "")) I'm getting an Incorrect Argument error. Help. Thanks!
-
Help with Question on formula - getting unparsable - eyes are crossed
Hi, I took my formula which worked in excel and have tried to reproduce it in smartsheet and I am getting an unparsable, I am going cross-eyed trying to figure out what I am doing wrong. Here is the formula if someone can help me figure it out. thank you - Amy =IF(AND(ISTEXT(ExpirationDate1), Datefirst1 = "", Datesecond1 =…
-
Formula to count checkboxes on a calculation sheet
I'm creating a calculation sheet to build a dashboard and am trying to count the number of checked checkboxes in a column on a different Smartsheet. The formula I'm using is: =COUNT({Deceased Accounts Consumer Lending Completed}, 1) It's giving me the total unchecked items instead of the total checked items. Can someone…
-
Which app is best to assist in pulling data from one sheet (autofill)?
Hi, Community, I am setting up an attendance sheet and would like to be able to start typing a name of one of my members and have it prefill from my control membership sheet (name), and then pull in the person's Title, Member Persona(s) and Track(s). Is that something best done with a formula, or Dynamic View, or Data…
-
Adding workdays based on date column AND specific criteria from another column
Hi team - I have a a sheet that has a column for Annual and Semiannual reports. I'd like to create a date in the Next Review Date column based on adding 330 days to the Current Review Date where the Doc Gov Document Revision Schedule entry is Annually (update every 12 months based on anniversary date) and add 150 days to…
-
Split Dates
Hi I am trying to get if split dates is in the last 7 days go orange and if split dates is 8 days in the past go red but it wont work it focus on the over the past 7 days only I enclose a image of my conditional formatting.