-
Help Getting Started - Newb
I am having trouble calculating the total cost of units purchased in Smartsheet. I have tried using the formula =SUMPRODUCT([Units Purchased],[Unit Cost]), but I get the error message #unparseable. Can you please help?
-
If / and / contains formula
Hello, Trying to get a formula to check an "active" box if two conditions are presents. Essentially when both these if conditions are true. IF(CONTAINS(Docs@row, {Active Docs}, 1, 0)) IF(CONTAINS([Trade Partner]@row, {Active Clients}, 1, 0)) Trying the below gives me an #INCORRECT ARGUMENT =IF(AND(CONTAINS(Docs@row,…
-
Updating Project Stage Advancement formula
We have a current formula for Project Stage Advancement, that updates the Project Stage field when all tasks under in the section have been marked 100% and a task in the next section has been marked In Progress. =IFERROR(INDEX([Task Name]:[Task Name], MATCH(MAX(COLLECT([Start Date]:[Start Date], Status:Status, OR(@cell =…
-
IF AND COUNTIF formula not working for checkbox field
Hello, I'm working on a formula in a checkbox field that is checked when the nominee is listed more than once in the Nominee field (contact field) and the Previous Month and Current Month fields are checked. This formula is what I've come up with but it isn't checking the Repeat Nominee field when it should:…
-
Day of the Week Calculation
I am trying to calculate the day of the week based on a cell reference. I am a new user so any and all help is appreciated. So far I have this am I on the right track? [DueDate]2 is the hard coded date that is in question. =[Due Date]2() + (7 - WEEKDAY([Due Date]2()))
-
Calculate number of leave days per employee per month
Hello. I am working on two sheets: Employee Entitlements and Leave Register. Sheet 1: Leave Application, where all the employees submit their PTOs. Sheet 2: Summary sheet, holds the summary of each employees' leave balance, days used, and leaves incurred per month. How do I calculate the number of leave days per employee…
-
Formula to Copy cells if no match?
I'm looking for a way (probably some sort of Index/Match formula?) to check for a customer name on 2 lists. If the name shows up on the second list, but not the first, add it also to the first list. Here is our specific set up: The first list is a workflow tracker where most people will start. The first step in the…
-
Quarter Differentials
Hello! I need to create a formula showing the differentials between quarters for two types of data - the total users and total shares for social media posts entered in the sheet. I created fields for Q2 User Differential and Q2 Total Share Differential and assume I'll need Sum and IF logic built in. For the Q2…
-
Help combining multiple if statements with countif from another sheet to get a symbol
I have so many columns! Is there a way to merge some of these formulas and get what I'm looking for in one or two columns? I want the system to look at the hours identified in the Week 1: Oct 1-7, 2023 column and then tell me if the reviewer is at capacity (with a symbol) based on the assignments assigned in another sheet.…
-
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…
