-
How can I create a material inventory and order form in the same sheet
Hello, I am very new to Smartsheets and am trying to streamline inventory and how our partners order materials from us. Currently, partners email members of our team and someone fulfils and tracks the order manually in an excel sheet. I want to create a sheet that tracks inventory with an order form that subtracts from the…
-
Formula Help - using multiple IFBLANKS in a single formula
Trying to make this work, but keep hitting a wall. We've built an escalation portal, and now I'm trying to pull some metrics out of it, including duration as a P1. I have 4 cells, P1 Date, P2 Date, P3 Date, P4 Date. I am trying to calculate the total number of work days between the P1 date and whatever the next date is,…
-
Help with collect formula with multiple AND arguments
Hi folks, I am currently using this formula, which works fine: =IFERROR((AVG(COLLECT({#Working Days to Kickoff with KP}, {Verizon Received Date}, AND(@cell <= DATE(2023, 1, 31), @cell >= DATE(2023, 1, 1))))), "") This gives me the average time we take to kick off our projects from the date we receive our projects from the…
-
Auto populate project ID based on identifier
Is there a way to auto populate a letter and number ID sequence based on an identifier? I'm trying to create a project ID based on business segment, state and have a number auto generated, but be sequential within the business segment. Ex: AB_FL_0001 AB_CA_0002 AB_FL_0003 CD_NY_0001 CD_LA_0002
-
If cell checked, pull in different cell value
I'm trying to pull a value from a cell into another cell if a different cell has a check mark. If the cell for the column 'Full Payment Received? is checked, insert the value from 'Amount of Bonus Owed' I've tried the following: =IF({Full Payment Received?}@row = 1, {Amount of Bonus Owed}@row) Thanks in advance for your…
-
Sheet Summary Countifs on columns with formulas
I'm trying to build sheet summary metrics utilizing countifs against multiple columns but the column ranges themselves have vlookups in it. Unless I hard code the column values so that they are static, my formulas won't work and giving the [No Match] error for my criteria. Is there a workaround for this?
-
Date Calculations
Hey y'all super new to this, I am trying to have the goal date be based on the Target open date less the days prior. The formula I have is " =Description1 + [Days Prior to Opening]@row " which returns the above. What am I doing wrong and how to do I fix it? Dependencies are turned off.
-
How to write a divide formula?
I have a formula that im trying to make that adds 3 criterion and divides the sum by a value. Can some one help with that what looks like.
-
vlookup question (sheet to sheet)
I think I need a VLookup formula but I'm stumped. I have 2 sheets where each row of data has an individual row number in a column--the data in each row is exactly the same. I need a formula on the secondary sheet to check the row number on the master sheet. If the row number on the secondary sheet matches the row number on…
-
Looking to Resolve #NO MATCH with a Multi-select Dropdown
I've tried many variations and got very close with: =IF(CONTAINS("Orientation", Course@row), INDEX({Course Start Date}, MATCH(Course@row, {Courses Dropdown Name}, 0)), "") - it only pulls when there is one selection provided in the multi-select dropdown and a "#NO MATCH" where there are more than one course selected. We…
