-
MM/DD/YYYY Formula vs. TODAY
I am new to formulas and looking for a way to populate the "How Many Years?" column on my sheet vs. today's date. Thank you in advance!
-
SUMIFS with wildcard (*)
Hello, I am trying to use the sumifs formula for summing values in one column based on the first two letters in another column. This formula is not working =SUMIFS([Total Invoiced]:[Total Invoiced], [Google Location ID]:[Google Location ID], "CA*") I have tried exchanging the criteria column at the beginning as well, and…
-
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for…
-
Trouble with an IF formula
Hello! I'm having trouble with an IF formula (combined with two COUNTIFS formulas as results) where I'm trying to count specific rows in a sheet based on certain criteria. The IF statement is to count status if the quarter is current or before, otherwise exclude status if the quarter is in the future. Both COUNTIFS…
-
Automation change cell value no longer being translated to a $$ value?
Hi, I've noticed this issue in two of my smartsheet processes. I have an automation set up as follows: "When rows are added are changed and [Column A] changes to [Any Value], change cell value in [Column B] to "60" " I then set column B to be $ currency format. Up until recently, "60" changed to "$60.00" without issue but…
-
Copy Parent Issue Key (link) into Child Row as a link
Hello! I am trying to pull the issue key link from my parent row into the child row. I have used the formula =PARENT([Issue Key]@row ) But it returns the text only, not a clickable link. Any ideas?
-
Count Distinct Using a Text Column with Values Separated by Commas
Hello! I have a column with a list of values separated by commas. I am looking to count the number of values separated by commas and eliminate duplicates. I have tried creating a helper column that converts the values to a multiselect, but I can't figure out the =COUNT(DISTINCT formula from there. Here is a screenshot…
-
Sum by Month in Report
I have a report created from 19 sheets - these sheets have delivery dates and project values. I want to sum by Month. See screen shot of what I have so far. I can't get it to sum, September, October, November and December independently. HELP
-
Metric Sheet - Not updating with Automation Date
Hello everyone, For the past year or two, I've been using automation "Record Date" set to daily as a trigger for the cross sheet references on this metric sheet to update. As of recently, it stopped updating the references despite the automation running and updating the date. Was there a change that broke this? Thank you.
-
Is there a better way to get the results I am looking for?
Good afternoon, all! I have been tasked with creating an in-depth catalogue of SKUs for my company. Currently, I have a set up that works but is going to be very manual with change management. I have one sheet that is my data dump. It has all of the information located in one spot. I am then going to need to pull this…