-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
SUMIF Contact? Help please!
I'm trying to get the total of a column where the row contains a specific sales person. Can someone help me out? Here is what I tried: =SUMIF([Sales Person]:[Sales Person], "Kevin", [Appx. Value]:Appx. Value]) Screenshot attached...thanks in advance!
-
Calculating Number of Items in a Month based on System Generated date field
Hello all - Needing help with a formula to calculate how many requests are submitted via a webform for each month. 2 questions related to this: 1. Can a formula pull just the month from a System Generated cell: Created by (Date)? 2. Where are errors in this formula: =COUNTIF({Date Submitted}, MONTH(@cell) = 1) 'Dateโฆ
-
CountIFs EOM Formula
Is there and EOM formula that will use the Month Column instead of manually using the DATE (2019,1,31) format? Excel example: =COUNTIFS(Type of Lead,"Servicing",Date Received,">="&B5,Date Received,"<="&EOMONTH(B5,0)) Smartsheet: =COUNTIFS({Type of Lead},"Servicing", {Date},>=DATE(Month1),{Date},<=EOM(Month1)) Any helpโฆ
-
Including FIND in COUNTIF
I would like to use COUNTIFS when two conditions are true * The value in College = "ED" * The text [Development Category] contains the word "Build". EXAMPLES THAT COUNT: College = "ED", [Development Category] = "Build OL only" College = "ED", [Development Category] = "Build BL only" EXAMPLES NOT TO COUNT: College = "ED",โฆ
-
Automate RYGGrey
I need help with a formula to automate my RYGGrey. Here are the rules: If status = complete, grey If status is in progress or not started and finishย is in the past, red If status is in progress or not started and finishย is today + 5 days (within the next 5 days), yellow If status is in progress or not started and finish isโฆ
-
vlookup vs. Match (identifying new form submissions compared to a static list)
Scenario: * I have a list of 200 customers that need to be surveyed by our team. * Some customers will receive multiple surveys, as they are served by multiple team members (our plan is to compile & analyze the results). * Although to meet our goal, only 1 survey per customer is needed * We are using a Smartsheet form toโฆ
-
% Date calculation
Hello, I need to create a % calculation for the number of dates meeting a 'launch' date. What is the best formula to use for this? I will have a long list of dates and I need one column to calculate how many of them are equal to or less than a launch date (25/03/2021). Any guidance would be greatly appreciated. Thanks,โฆ
-
count if formulas
I would like to count how many of my orders do not have PO number (i.e Po Number cell is blank) Can you help with the formula to do this Thanks
-
Date ranges and symbols
I am looking for a formula to automatically change a symbol colour based on contract expiry dates. Here is what I need each symbol to signifyย about the expiry date columnย - Green dot = If the contract expiry date is greater than 365 days from today Yellow dot = If the contract expiry date is less than 365 days away fromโฆ