-
I am trying to pull a list of unique values from one sheet to another
I am trying to pull in a list of distinct values to sum. I have a sheet with a project number, date, and a value (project id, date, amount) and I have merged all of those together for a helper column. Now I want to pull that helper column's distinct values into another sheet once. The original sheet may have the values…
-
I am trying to total a score with all the stars that are checked to count as 1 score each.
My formula is not calculating with the columns and a , 1. I think I am missing something.
-
Formula Help
Can someone help be fix the below formula, which keeps coming back as unparseable? I need it to say "Yes" if both of the values in the two specified rows exceed a certain value, and "No" if they do not. =IF([Impact %]@row>50%]AND[Probability %]@row>50%], "Yes", "No")
-
Automated Timesheets
Hello, I'm not sure if this is the correct section to ask this, so if not then I apologize. I'm looking into the possibility of creating an automated timesheet system using a scannable barcode (or QR code), so that once scanned, there is an automatic "clock in" or "clock out". In testing I was able to scan barcodes/QR…
-
Adding a date once items are submitted to a sheet
I have a column titled "Did It Rain?" Yes or No. I want to record a date in the "Actual Date" column. Here is my formula. =If(or([Did It Rain?]@row = "Yes", [Did It Rain?]@row = "No"), Today(), If([Did It Rain?]@row = " ", " ")) I had it working for Yes and No, but want it to stay blank if the row has not been given a yes…
-
Identifying Duplicates
Hi I'm trying to work out a formula for identifying duplicates in a invoice column. what formula would i use and do i setup a separate column to populate the answer to the formula? my column name is 'Invoice No' thank you for your assistance.
-
Return Values Help Required 😁
Hi all, I am hoping that someone can offer advice or a solution to my following questions. I have attached screen grabs and all the information I think will be relevant, please see below I have two sheets that I use as an asset tracker and the screen grab you see above has a form linked to populate the columns. I would…
-
Quickly add columns for dates
Looking for help, is there a way I can quickly create a block of columns for month/date columns:
-
Help with converting inherited Excel Formula
Hello, I have inherited this formula from an excel sheet that i can trying to get working in Smartsheet however as a novice... i am struggling. Grateful for any support. =IF(M10<=5,"Low",IF(AND(M10>=6,M10<=11),"Medium",IF(AND(M10>=15,M10<=25),"High",IF(AND(M10=12,K10=4),"High","Medium")))) Protonspounge
-
Multiple formulae per column based on another column value
Hi, I currently use the level column to automatically assign a level number based on the indent value of status of the parent rows. Child rows remain blank in this column. In the % Planned column I use two formulae to calculate where my project is meant to be: Parent rows use =IFERROR(AVGW(CHILDREN(),…