-
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…
-
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.
