-
Looking for a formula to compare two columns, and enter true or false in a third column
The two columns will each have an 8 character string, want the formula in a third column to put True or False into the cell. Thanks in advance, Joe Busch
-
Pulling Purchase price from a master sheet
Hey All, I have a master sheet where I input items that I purchased and it's price. To identify a product I use SKU's for each Product. Now every two weeks I pull my sales and import it to a new smart sheet. The I copy the sku and go into my master sheet and find it there and look at how much I paid for it, then I got back…
-
Setting up an Average Filter across multiple columns
Hello All I'm new to Smartsheet's and still learning formula. So hoping someone can help with this for me as I'm struggling to figure out what I'm doing wrong? I require a sheet that will give me the average number of hours an organizer has spent on a completed project per given month See above When creating the formula I…
-
Is there a conditional formatting rule that shows if a date is more than X years in the past?
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. I can only find the function for "in the past" without any way to add to the formula how far in the past. Is it possible to set parameters on past dates? It seems like this should be…
-
If Function
Hello, I'm trying to use the IF function, if column "Type Of Request" is "SCRAP" to automatically insert a negative sign into the "Value" column in front of the number. If it's something other than "SCRAP" then to leave the number alone. Maybe I'm just overthinking it a little too much.
-
How to ROUNDUP a SUM?
Hi! I wrote a simple formula to =SUM a few columns into a total. =SUM(([Column1]@row * [Column2]@row / [Column4]@row)) How do I add the ROUNDUP function with the proper syntax? Right now, without ROUNDUP, the total sum has 4 decimal places and trying to knock that down, either to none, or two max. I am not a scripting…
-
Autofill Dropdown Menu
Hi all to formula geeks! I am looking for a formula to fill in automatically the Day 1 (Badge Code) drop down column. If any of the 4 columns of different conferences Oct 26 (in light yellow) contains "1", then the Day 1 (Badge Code) Column will autofill with the corresponding badge code/s. Multiple badge codes are…
-
Decrement a funding total
Hello all you formula wizards ~ I'm down to the last test of a travel request module and I realize my formula is not working correctly so I'm looking for some guidance. I have an intake sheet where requests are submitted, then reviewed and approved, which moves the data to another sheet for further approvals. I need to be…
-
Populate a project template from a form submission
Hi! Is it possible to generate a new project when a form is submitted? And, map form fields to cells in the project template? And, link the new project template to the sheet that the form feed into? Thanks for any help! Sarah
-
Help with IF Statement with multiple SUMIFS
Hello, I am trying to sum up a range of data from two spreadsheets based on the same criteria. Here is my formula which is throwing an #UNPARSABLE error and I cannot understand why =IF(SUMIFS({Advertising Total Cost}, {Hardi}, =$Region$1, {Year}, =2021, {Month}, =[OCT-21]$1, {contract}, =CATEGORY@row) AND(SUMIFS({misc…