-
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
-
IF Formula Help
Hello! I'm looking for assistance with creating a formula to return a value on the New Hire Sheet pulling a result from the Offer Sheet. Specifically I'm looking for the following: When the [Primary Column]@row = "Completed" on the Offer Sheet, I need a formula to return the "Candidate Name" from the Offer Sheet in the…
-
Complex Logic Statements
It might not even be possible, but I need to know how to have a cell be populated with a value based on multiple criteria. Scenario - every audit costs a different amount, if it is 2 day or 3 day, remote or onsite, etc. I would like the line item to be able to populate based on column B = number of days and column C=remote…
-
Need help with a formula putting 4 different critera together from 2 columns....
Hello. I have alot to learn about formulas! I have Impact and Effort columns in my sheet. I want to evaluate those numbers (1-6) and give a return in an Impact/Effort Quadrant column. Currently I have this formula which works: =IF(AND(Impact@row >= "4", Effort@row >= "4"), "Major Project") The other variables I need to add…
-
I try to move row and I get an error that does not seems to make sense
here is the error message: There is no formula anywhere in the sheet.