-
IF FORMULA FOR GOING-TO-EXPIRY EXPIRD-SOON EXPIRED AND VALID CERTIFICATE
My criteria are the following: If the Expiration Date Column cell is more then (60) days remaining = “Valid” If the Expiration Date Column cell is less then (60) days = “Going to Expiry” IF the Expiration Date Column cell is Less then (30) days = “Expired Soon” IF the Expiration Date Column cell is between (0) days to…
-
Help with Summing Hours Based on Cost Codes Across Sheets
Hi everyone, I’m trying to calculate the total hours worked by cost code across two Smartsheet sheets, but I’m hitting a formula limit on my primary sheet, where I track time entries. Setup: I have a timeclock sheet where employees log their hours, and each entry includes one or more cost codes in a single cell to indicate…
-
Creating custom formula to auto-display negative number (cost credit)
My company is moving to Smartsheet to consolidate what we normally keep in multiple locations. One of these locations is Excel, where we track project spending and budgets. I've figured out how to use cross sheet referencing to calculate costs and credits and have them show on the master budget tracker. It was a bit of a…
-
Multiselect values being treated as one group instead of separate values.
I have a join(collect) formula set up to look for a matching value and to return all of the test names that the restaurant (matching value) is running. That test name can have multiple restaurants selected in a multi-select dropdown column. When I have one restaurant selected, this formula works great. When there is more…
-
Return latest value from another column's latest rows
Hello, I have a sheet in Excel I'd like to move to smartsheet to work with a client's team. The only problem I have is with the fields "Previous Cumulative Partner Discount" and "New Cumulative Partner Discount" as they have formulas that involve each other column in theirs and in Smartsheet it returns the circular…
-
COUNTIFS X or Y or Z (Check boxes)
Hi can I get assistance in writing a formula for the following: =COUNTIFS({CSN}, ([NOV 5]:[NOV 5], or 1, [NOV 6]:[NOV 6], 1 ,or [NOV 7]:[NOV 7], 1)
-
How do you transpose data?
I need the information from Column 1 - rows 2-10 to be Flipped or transposed into Row 1 - Columns 2-10. In the sheet below 1 would stay in the same spot. Cell with "2" would need to move to Row 1, Column2. What function can I use to complete this?
-
Creating an inventory
I have one sheet that is completed via a form. In the column Summer Shirt Issued, there are multiple options that must be selected. 2, women, X-Small. This indicated the number of shirts issued, the cut, and the size. I then want to reference this to my Current Women's Uniform Inventory sheet to deduct from the total…
-
IFERROR with Index / Match from 3 sheets.
Hi All, Trying to search value from 3 sheets and using IFERROR with Index / Match and am getting Incorrect Argument error. =IFERROR(IFERROR(IFERROR(INDEX({Project Intake Project Name}, MATCH([Project ID]@row, {Project Intake Project ID}, 0))), INDEX({Completed Project Name}, MATCH([Project ID]@row, {Completed Project ID},…
-
Compare two columns and return a yes or no
I have two columns on one sheet that I want to compare. If the value in Column A matches any value in Column B, I want a yes to be returned in Column C. I've played with the formula for over an hour and can't get it right. =IF(CONTAINS([RDS Serial #]@row, [Serial Number]:[Serial Number]), "YES", "NO")