-
Return data for latest instance of unique records
I have a few tables which are populated by form submissions where users are presented with list of vehicles, key rings, etc... These unique assets repeat in the same table over and over each time a new row is inserted in the same table. For example, vehicle number 104 his submitted each month. There are a total of 96…
-
How do I convert dates into a time period (month) for reporting?
I am creating a savings dashboard and my primary sheet records the date the PO is issued. In my dashboard I want to display my savings by month or fiscal period. Is there a formula that will convert my rows with PO issued dates between date ranges into a fiscal period/month. Example: I want to convert row cells with any PO…
-
Formula for Fiscal Year
I am trying to create a formula to track Fiscal year by month and Year. I have a column for the Month and a column for the year. The fiscal year date range I am creating is anything between 4/2023 and 3/2024 = FY2024, anything between 4/2022 - 3/2023= FY2023.
-
SUMIF with CHILDREN, if greater than 0
I am just migrating to Smartsheet from Excel. Smartsheet is missing some basic things, but I'm trying it primarily because of the Indent/Children functions, which are something I love. I've got some data in, and the =SUM(CHILDREN()) function works well, but I don't want a bunch of 0's all over my sheet, so I've been trying…
-
Help with Collecting Data for Metrics w/Multiple Criteria
I need help to collect a sum of financial information based on a range of dates in the future (or past) SmartSheet Name: Renewals-Active Column Names: 'MRC' is a text/number column and contains the financial information 'Estimated Contract Exp. Date' is the date column that contains dates (past, today and future) 'Primary…
-
Using =IF(AND) formula
Hello, I'm trying to create a sheet summary formula that will return a "1" result if the following criteria are met: 1) the Sheet Summary field "Application Status" is showing "APPS ON HAND", and 2) the date in the sheet summary field "Oldest App on Hand" is more than five days prior to the current date. Otherwise, I want…
-
How to combine these formulas
=INDEX({Do Not Use Art List Range 1}, MATCH([Distributor Name]@row, {Do Not Use Art List Range 2}, 0) =INDEX({Do Not Use Art List Range 1}, MATCH([ARTNAME}@row, {Do Not Use Art List Range 2}, 0) I can get these two formulas to do things on their own but can't put them together right to get the same result. I don't need…
-
Inventory Management Help
Hi Samrtsheets Community, I am looking at using Smartsheets to manage all of the furniture inventory that we have for photoshoots. I would like to add either bar codes or QR codes to all of the inventory. When someone scans an item, it opens a form that already have the item number, picture of the item, description all…
-
Case sensitive formula
I have a formula that is check to see if the event IDs are the same and if yes then return the total registration. The problem is that some of the event ID's look the same but are different due to case sensitivity. Is there a way to ensure that it is also checking the case? current formula =IFERROR(VLOOKUP([Event ID]257,…
-
Generate an AutoNumber based on "Yes" being selected in a drop down
This formula seems to be in error - I get #UNPARSEABLE =IF([MY FIELD NAME] = "Yes", AUTONUMBER(), "") It would be even better if I could create the number when a checkmark is selected in another column. EDIT: I am trying this for the checkbox: =IF([MY FIELD NAME]@row, AUTO_NUMBER(), "") My field format is Text/Number